Need help to derive below below 5 Measures DAX Expression.
There is 2 Datasets name:Benchmark and CompletionFactor with no relationship in PowerBI Model
Note: ForecastRate is calculated measure
All 5 DAX Expression should be in CompletionFactor
Explanation for each DAX Measure
1) Rank: ForecastRate (Measure) from CompletionFactor Dataset needs to compare with benchmark dataset between MIN and MAX Value and get the Rank
2) NextTierUpRank : based on the currentRank what is the next level incremental rank..
if its reaches 5 then the max rank will be 5 only
3) NextTierBelowRank: based on the currentRank what is the next level decrease rank.
if it is reaches 1 then it should be 1 only.
4) NextTierUpMinValue: based on NextTierUpRank get the Min Value from Benchmark Dataset
5) NextTierDownMaxValue: based on NextTierBelowRank get the MaxValue from Benchmark Dataset.
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
Register by September 5 to save $200
Check out what's new in the Power BI Community!
Continue your learning in our online communities.