Dax calculated column with IF

[nkasdali]

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

QuadrantTurnover V2 = 
Var vTurn = Data[Turnover/Month] //default field in my table
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")

and honestly, i can't understand the result ! :

PercentileTurnover is a measure  : 

CALCULATE(PERCENTILE.INC(Data[Turnover/Month];0,8);ALLEXCEPT('Data';Data[EAN];'Data'[Country];Data[Product];'Data'[Time Period]))

what i'am doing wrong ?

thanks for your help 🙂

[v-cherch-msft]

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]

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]

Hi @nkasdali 

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

Regards,

[nkasdali]

hi @v-cherch-msft 

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

[v-cherch-msft]

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,