how to count values of a measure

[ahmedelgibaly]

Hi Experts,

I need help on how to count data that is resulted from a measure. 

As per the below screenshot, I used the "Datadiff" function to get the numbers between 2 different dates "POR to Scopping" . Now i need to count how many "POR to scopping" that are more than 14 . The problem is that "POR to Scopping" is a measure and i can't get the "Count " function to work for measures and it only worke for columns!

[Greg_Deckler · Accepted solution]

Use COUNTX or COUNTROWS. Build a table using FILTER and perhaps ADDCOLUMNS that represents your table. Then use COUNTX against that table, perhaps with an additional filter for > 14. For example:

Measure Count = 
VAR __table = ALL('Table')
VAR __table1 = ADDCOLUMNS(__table,"__MyMeasure",[Measure])
RETURN
COUNTROWS(FILTER(__table1,[__MyMeasure] > 14))

[ahmedelgibaly]

HI Dreg,

Thanks for the feedback!

I got it working by using the below statment :

Number of sites exceeding "POR To Scopping" Std Interval =

CALCULATE(COUNTA('Query1'[Site ID]), FILTER(Query1,Query1[POR to Scoping]>=14),FILTER(Query1,Query1[Site Scoping Sts]="P"))