Forum Discussion
Power BI Calculations w/ Grading Scale
Hello,
I currently have 4 different Calculations from 4 separate csv tables as data sources. In addition to this, I have a csv file that functions as a predetermined grading scale. It lists theoretical scores with a predetermined grade in a column right next to said scores. An additional column repeats whatever the 'measure title' of the Calculation is, as each of the 4 Calculations has its own individual grading scale. Is it possible for me to set up a view that says if 'Measure 1' = X%, find Measure 1's metric name on the grading scale table, then find the X%, and lookup whatever grade is listed next to that specified score? Unfortunately, it isn't an easy ABCD grading scale, but rather each score % has a grade % that is only a fraction different, for some metrics there's a greater difference than others.
Trying to solve: If calculation name = "Revenue", find the scores and grades for measures titled as "Revenue", lookup using the result to pull the grading.
1 Reply
- lbendlin
Super User
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
