Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Greetings to all,
A little context before posting my question:
Monthly, I evaluate the results meetings in the place where I work. In this meeting, indicators that deviated during the month are presented. I give a score (1, 3, 5) for the analysis of the indicator and also for the countermeasure.
I have two tables as the attached file:
In table 1 it is possible to find the table that I use to annotate the score of the analyzes and countermeasures.
For area A1, in March, 4 indicators had deviations. The maximum score that A1 could have in the month would be 40, but according to my evaluation, it was 32 (80%). However, this value represents only 20% of the final score, that is, the score will be 16%. I managed to reach that value using some measures.
In table 2 I note if the meeting of the month took place.
Basically, if the meeting took place, the Area makes 15% of the score. For this, I created a Calculated Column using IF.
In March A1 held the meeting, then + 15% for the score.
Here is my question:
I need to sum these two values (16% + 15%). However, when I sum the two measures, the result is 46%.
Any ideas how to solve?
Best Regards,
Solved! Go to Solution.
Hi,
I am not sure how you could get the result of 46%, but I might assume that the Month-Filter did not apply to Table_2. So, the calculation might be 16% + 15%(Table_2_March) + 15%(Table_2_April). Please correct me if I wrongly understood.
The below picture is what I have done. Please check.
I also wrote pbix file link down below. You can see all measures in the file.
https://drive.google.com/file/d/18lmRMdqE1MfTLOjf-qwI5U2BXTOvhxgW/view?usp=sharing
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
I am not sure how you could get the result of 46%, but I might assume that the Month-Filter did not apply to Table_2. So, the calculation might be 16% + 15%(Table_2_March) + 15%(Table_2_April). Please correct me if I wrongly understood.
The below picture is what I have done. Please check.
I also wrote pbix file link down below. You can see all measures in the file.
https://drive.google.com/file/d/18lmRMdqE1MfTLOjf-qwI5U2BXTOvhxgW/view?usp=sharing
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi @Anonymous
I don't have access to that link. Google won't let me in.
regards
Phil
Proud to be a Super User!
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |