Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
HI!
I have a query with regard to comparing Measures to evaluate something and I am struggling with how this can be done.....
An example of this is shown below. I have Employees in a Table that has multiple scores for on performance against a wide range of activities. However, I have created a Measure (Measure 1) that determines the score for the selected activity.
I have another Measure (Measure 2) that is an expected score for the selected activity, so this is constant for a selected activity whereas individual scores will be different.
What I am looking for is something that allows me to compare the result of Measure 1 against Measure 2 and then allow me to make an evaluation such as categorise the result in a range or percentage. I am sure this should be easy to achieve but I am not getting there......any suggestions would be great!!
Solved! Go to Solution.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @DavidH ,
If you already have both measure just make a new one that makes the difference between both:
Measure 3 = [Measure 1] - [Measure 2]
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsMFelix,
Many thanks for your response! I was having trouble with one of the measures but now that has been corrected.....
Ok so the simple answer is fine as my measure has been corrected
Now I need to capture the results of the calculation in a table and I understand that this is possible to do but not sure on how to approach this? I have set up 3 criteria from the subtraction result [Measure 4] in that for ease if the result from the subtraction is;
0 = "Authorised"
1 = "Authorised Partially"
2 or greater = "Not Authorised"
So I would like to capture this result now in a new table so I am able to visualise this. I am sure this is possible using another measure by setting up a variable and a virtual table??
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
101 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
98 | |
97 | |
73 | |
72 |