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.

       

       

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

        Hi nkasdali 

        Could you share some simplified assumed sample data instead of table visual to reproduce your scenario?It is very hard to provide the solution without looking at sample data.You can also upload the .pbix file to OneDrive and post the link here. Do mask sensitive data before uploading.

        Regards,