This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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,
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])
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..