DAX Help

[Happy2023_05]

I want to achive the below logic in measure.pls help me.

If (variance)>=100% then I have to count(table[coln1]).

Variance  is a measure. DAx is not allowing to use 100% for measure in if condn.

[amitchandak]

@Happy2023_05 , if it has been marked as % that means 1 is 100%

a new measure

if([Variance] >1, count(Table[Column1]), [Variance])

[Happy2023_05]

Got it. When I keep the measure in card visual it shows blank so what I did is I created measure like this. Measure1=If([measure]>1,1,0)

so now I want to see the sum of the number of one's.

For eg

Category.   Measure. Measure1

Fruits.          101%.   1

Flowers.        101%.   1

Accessories   99%.  0

Now I should get value as 2 in card visual

I tried below measure but not working

If([measure]>1,count(category)) ths measure is showing blank n card visual.