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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
MCacc
Helper IV
Helper IV

Dynamic measure to compare values based on selection

I have to create a measure that compares values in columns based on selection from a slicer. 

 

The selection is multiple choice and doesn't follow a specific order.

 

I have the follow measure which creates a Rank and it works fine, it returns incremental number based on the selection. 

 

What I struggle to achieve is to write a measure that basically compares the values in the columns: 

MCacc_0-1698327643138.png

My arrow has to change, goes up and down based on the value on the cell in the column next to it.

 

Do you have any suggestion? 

 

Thanl you

2 REPLIES 2
amitchandak
Super User
Super User

@MCacc , now very clear, check if offset can help

 

Continue to explore Power BI Offset Compare Categories, Time Intelligence MOM, QOQ, and YOY: https://youtu.be/5YMlkDNGr0U

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Thank you so much for your input but unfortunately it doesn't work.

 

I tried the function both in a measure and in a calcolated column but the values returned are blank.

 

This is what I did: 

MEASURE 1 = MAX(TABLE[SEVERITY]

 

and then:

CALCULATE([MEASURE], OFFSET(-1, ALLSELECTED(TABLE[DIMENSION1_VISUAL]))

 

* Field SEVERITY is a string

 

* DIMENSION_VISUAL is the field I use in the rows for my table visual

 

Of course I can have N values of SEVERITY for my DIMENSION1_VISUAL, but as soon as I select all my filters the rows become 1.

 

Thank you again, for your kind suggestion. But please let me know if you any other ideas 

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors