Forum Discussion

nkasdali's avatar
nkasdali
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Dax calculated column with IF

Hi All, I need your help in dax matters.   I'm trying to add a column into my dataset as flag to identify if my value is greater then the Percentil if this same value : here my dax   QuadrantTur...
Need Help
Show and Tell
Tips and Tricks
v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi nkasdali 

You may create the measure like below:

QuadrantTurnover V2 =
VAR vTurn =
    SUM ( Data[Turnover/Month] ) 
VAR vPerc =
    CALCULATE (
        PERCENTILE.INC ( Data[Turnover/Month]; 0,8 );
        ALLEXCEPT (
            'Data';
            Data[EAN];
            'Data'[Country];
            Data[Product];
            'Data'[Time Period]
        )
    )
RETURN
    IF ( vTurn > vPerc; "TOP"; "BOTTOM" )

Regards,

  • nkasdali's avatar
    nkasdali
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    hi v-cherch-msft 

    i thought about the measure, but, i'll lose the flag after ! i want to use the field as slicer.

     

    regards

    • v-cherch-msft's avatar
      v-cherch-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      7 years ago

      Hi nkasdali 

      If you want to use the field as slicer.You may create a calculated column.

      Regards,

      • nkasdali's avatar
        nkasdali
        Icon for Microsoft Employee rankMicrosoft Employee
        7 years ago

        hi v-cherch-msft 

        that exactly what i did :), sorry i didn't mention it.