I have a measured column that has different values. Now I am creating a measure to display on a card which should compare a specified value to all rows of the calculated column and give a count.
I tried the following but it is not working and showing blank:
Table1[Asia] =
VAR oAsia = CALCULATE ( [Avg] + ( [stdv] * 3 ) )
RETURN
CALCULATE ( COUNTROWS ( Table1 ), FILTER ( 'Table1', Table1[Asia] > oAsia ) )
Table1[Asia] is giving the sum of all values of the calculated column instead of the individual row value.
Retailers Asia USA
------------------
A 1 5
B 6
C 2 7
D 2
E 3 3
F 1
G 4 4
