This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 18%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELD%3C/text%3E%3C/svg%3E)
Hi
I am migrating a report from SAP BO to Power BI. One of the measure is used there is like below
=Count([ColumnA]) Where ([Table].[ColumnB] = "....." )
How to replicate the same in Power BI using DAX.
Please advise..
How to create a measure Max values based on multiple columns is still awaiting a feedback...
Hi @Lukas Yu -MSFT
Thanks a lot for the suggestion.
Didn't tried your solution yet, will try the suggestion and let you know how it goes..
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 9%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELY%3C/text%3E%3C/svg%3E)
Hi,
The DAX expression should be like :
= CALCULATE (COUNT([ColumnA]),'TableName'[ColumnB] = ".....")
Lukas
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
What can I do if my transaction log is full?--- Hot issues November
How to convert Profiler trace into a SQL Server table -- Hot issues November
Thanks @Lukas Yu -MSFT . Your suggestion worked.
Hi @Lukas Yu -MSFT
Tried the suggestion and it is working but I need a small tweak in the formula I guess. There are some blanks in the filter column and the formula is counting that too. So I used DISTINCTCOUNTNOBLANK function in the formula and it still counting the blanks and giving extra values.
Example: The value should be 12 but as there are blanks in the column it is showing 13.
Please advise...
filter column
Did you mean ColumnA or?
You could try this :
= COUNTAX(FILTER('TableName',[ColumnB]="...."),[ColumnA])