Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
DavidH
Helper I
Helper I

Comparision of Measures to evaluate a result

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!!

 

Example Table.PNG

1 ACCEPTED SOLUTION

Hi @DavidH,

Measure are based on context this means that depending on the filters, slicers, axys setup or column you add to a visual the measure is calculated accordingly.

In you case there is no need to create a new table using the table visual you can add the columns (to give context) alongside with the measures and they will be calculated.

The only thing that you need is to create make that measure 4 has a syntax similar to this

Measure = SWITCH([Measure4] ; 0 ;"Authorised";1 ;"Authorised Partially"; "Not Authorised")

Regards,
MFelix

Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

3 REPLIES 3
MFelix
Super User
Super User

Hi @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


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



MFelix,

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 Smiley Happy

 

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??

Hi @DavidH,

Measure are based on context this means that depending on the filters, slicers, axys setup or column you add to a visual the measure is calculated accordingly.

In you case there is no need to create a new table using the table visual you can add the columns (to give context) alongside with the measures and they will be calculated.

The only thing that you need is to create make that measure 4 has a syntax similar to this

Measure = SWITCH([Measure4] ; 0 ;"Authorised";1 ;"Authorised Partially"; "Not Authorised")

Regards,
MFelix

Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.