Forum Discussion

vijay273162's avatar
vijay273162
Icon for Helper III rankHelper III
4 years ago
Solved

IF condition HELP

HI In below table, I need to return 3rd row "GM" Company with "1" in [IF 80%] measure. I write DAX as.... [IF 80 %] = IF([**bleep**. % of Total] <0.8,1,0)   Note : [**bleep**. % of Total] & [Ran...
power bi
  • V-lianl-msft's avatar
    V-lianl-msft
    4 years ago

    Hi vijay273162 ,

     

    Try to create a measure like below:

    IF 80% = 
VAR MIN_ = MINX(ALL('Table'),ABS('Table'[cum %of total]-0.8))
VAR VALUE_ = CALCULATE('Table'[cum %of total],FILTER(ALL('Table'),ABS('Table'[cum %of total]-0.8)=MIN_))
RETURN IF([cum %of total]<=VALUE_,1,0)

     


    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
4 years ago

IF 80% = VAR _rx=[Rank] RETURN IF(CALCULATE([**bleep**. % of Total],FILTER(ALL(Table[Company]),[Rank]<_rx))<0.8,1,0)