Forum Discussion

Happy2023_05's avatar
Happy2023_05
Helper I
3 years ago

DAX Help

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.
Need Help
amitchandak's avatar
amitchandak
Super User
3 years ago

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's avatar
    Happy2023_05
    Helper I
    3 years ago

    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.