Forum Discussion
Rankx Measure
Hi Everyone, I made the following measures and would like to Total the Count Measure by Manager but it is not working. Here's the two measures : Measure 1:
Brands Vol Sales minus Categor...
Assuming your measure 1 is doing calc correctly, try this and see if works
Measure 2:
# of Accts growing faster =
var _m1Value = CALCULATE ( [Brands Vol Sales minus Category Vol Sales])
RETURN COUNTAX(
-- For all the values in the Geography
VALUES(Table1['NB Share'[Geography]),
-- Check if the value is > 0, then 1 else dont count
if( _m1Value > 0, 1, BLANK() )
)
Thank you for the reply! That didn't work but what I ended up doing was make Measure 2 a calculated column, and then did a COUNTROWS measure and that worked.
The code I provided is for measure and interesting why it did not work.
No worries, you got working as a calculated column. 🙂