Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all
i have a graph calculated with a measure like this
Salesman Measure Needed dax expression (divide Measure to previous)
George 90% blank
Anna 30% 33% (divide 30%/90%)
John 20% 66% (divide 20%/30%)
Michael 10% 50% (divide 10%/20%)
The Salesmen have associated a rank behing and are sorted after it; but not all salesmen are selected so the rank is not consecutive
George 5
Anna 6
John 9
Michael 10
Thanks,
Cosmin
Solved! Go to Solution.
HI, @cosminc
Just try this formula to create a measure
Result = VAR _LASTRANK=CALCULATE(MAX('Table'[rank]),FILTER(ALLSELECTED('Table'),'Table'[rank]<MAX('Table'[rank])) ) RETURN DIVIDE([Measure],CALCULATE([Measure],FILTER(ALLSELECTED('Table'),'Table'[rank]=_LASTRANK)))
Result:
here is pbix file, please try it.
Best Regards,
Lin
HI, @cosminc
Just try this formula to create a measure
Result = VAR _LASTRANK=CALCULATE(MAX('Table'[rank]),FILTER(ALLSELECTED('Table'),'Table'[rank]<MAX('Table'[rank])) ) RETURN DIVIDE([Measure],CALCULATE([Measure],FILTER(ALLSELECTED('Table'),'Table'[rank]=_LASTRANK)))
Result:
here is pbix file, please try it.
Best Regards,
Lin
it works perfect!
Thanks!
Cosmin
in your Rank function use ALLSELECTED instead of ALL
Hi,
Rank used is not a function, is in source
Thanks,
Cosmin
Possible to upload some sample data?
it's a huge base
please try to upload the direct example from the top
Thanks,
Cosmin
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |