Forum Discussion
Help needed with DAX
Anonymous
You can create a measure, if an ID is repeated show the count of the ID otherwise return 0.
CountIfRepeat = IF(COUNT([ID])>1,CALCULATE(COUNT('Table'[ID]),FILTER(ALL('Table'),[ID]=MAX([ID]))),0)Best regards
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
I have a table with ID and Extension ID. I want to calculated how many times an extension was filed for each ID. If no extension is filed, then it should retun 0 else return the total number of extensions for each ID.
Firstly, I applied a conditional formatting in Power Query Editor - if Extension Id is blank, then it should return 0 else return ID (see the table)
In table visualization, I want the number of extensions for each ID. So, it should reflect something like this
I hope this sample is easier to understand. Any help would be appreciated. Thank you.
Community ChampionAnonymous Text data please.
Power Query Editor ID Extension ID Conditional Column A1 0 B2 0 C3 11 C3 C3 12 C3 D4 0 E5 13 E5 E5 14 E5 E5 15 E5 F6 0 G7 16 G7 G7 17 G7 Conditional column is formatted field - if Extenson ID is 0 then 0 else (select column) ID
Desired Output ID # of Extensions A1 0 B2 0 C3 2 D4 0 E5 3 F6 0 G7 2