Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 🙂
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,
i thought about the measure, but, i'll lose the flag after ! i want to use the field as slicer.
regards
Hi @nkasdali
If you want to use the field as slicer.You may create a calculated column.
Regards,
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,
User | Count |
---|---|
101 | |
90 | |
78 | |
70 | |
69 |
User | Count |
---|---|
110 | |
96 | |
95 | |
74 | |
71 |