Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, need help with a measure.
I'm trying to calculate the Score based on daily Variances.
The Scores Table looks like this..
Forecast Nos | Variance Min | Variance Max | Score |
1 | 0 | 0.05 | 5 |
1 | 0.05 | 0.1 | 4 |
1 | 0.1 | 0.2 | 3 |
1 | 0.2 | 0.3 | 2 |
2 | 0 | 0.05 | 5 |
2 | 0.05 | 0.1 | 4 |
2 | 0.1 | 0.2 | 3 |
2 | 0.2 | 0.3 | 2 |
The table goes for 3000 or so rows and scores eventually change depending on the Forecast Nos getting larger. A Score of 1 to be applied if variance is out of the above ranges.
The measure will need to look at (filter) for the forecast call numbers to get the ranges
Also, if the Forecast Nos is greater than the number of rows in the above table so the last Forecast Nos variance ranges and scores are to be applied to that.
The Variance measure to get the Score from the Score Table is the following..
Solved! Go to Solution.
Hi @bassmaninaus_PB ,
What is your desired output?
Please provide more details with your desired output and pbix file without privacy information (or some sample data) .
How to Get Your Question Answered Quickly
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the info, next time I'll try to get sample data.
Hi @bassmaninaus_PB ,
What is your desired output?
Please provide more details with your desired output and pbix file without privacy information (or some sample data) .
How to Get Your Question Answered Quickly
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
22 | |
12 | |
8 |
User | Count |
---|---|
76 | |
50 | |
46 | |
16 | |
12 |