Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills 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êsCheck out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!