Compare values from 2 visualized tables in powerbi dashboard (NOT BACK END TABLES COMPARISON)

[DMSJennifer]

Hi there, 

I have a challenge for the expert powerbi community!! Within my company we are currently looking to compare two table values in the powerbi dashboard (FRONTEND) to return an marker wheter the individual green value (which is filtered by "studiegroep", "periode" & "voornaam") meets the groupbenchmark pink value (filtered by :"benchmarkyear" but with changing data based on a backend division of data). 

Using PowerQuery within the tables is not possible given the pink data is changing when using diffent filters (so the pink data is not directly from another back-end table but is only generated in the dashboard by using measures & filters in the dashboard.

Normally in excell you would simply make a calculation based on the respective cells (see example below) and add a conditional formatting, see example in excell. However, I am looking for a similar solution within the powerbi dashboard. Is this possible in PowerBi?

would love to hear from anyone who can offer help! 

 

[ValtteriN]

Hi,

You can create a conditional measure which returns 1 or 0 based on the "cell value" or in this case matrix position.

In my example I have two tables similarly to your case example:

Unfortunately since the dimensions in your example we have to do some hard-coding similarly to referring cells we will be referring to values.

Dax:

Conditional format for group =

var _dim1 = MAX(ConditionalMatrix[Dimension])

return

If(

SUM(ConditionalMatrix[Value]) //same as current "cell" value

>=

CALCULATE(SUM('Comparision conditional matrix'[Value]),ALL('Comparision conditional matrix'),'Comparision conditional matrix'[Dimension]=_dim1,'Comparision conditional matrix'[Selection]="group"),1,0) //comparion "cell" value

Place the measure here:

 

End result:
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

[DMSJennifer]

Hi @ValtteriN,

Thanks for your time, its means a lot. However, it is not exactly what I am looking for but you might still be able to help. 

To clarify a bit more let me explain were our data is coming from:

Pink: Front-end

Green: Back-end 

With this in mind I've looked at your solution, which would work if in my example the  "group" matrix shown would come from a back end table (like you created two tables, which allowed you to make a difference back-end measure "conditional format for group" with the different values (that exist in a backend table).

However, this is not the case, the data that I use as a comparison - in the "group" dashboard matrix - is only shown in the front-end dashboard, so it does not exist as back-end table or value. Its merely showcasing data calculated in a front-end measure (and based on different filters), so there is no actual value that I can reference in a dax formula. Or at least this is where I am stuck. I would like to reference specific data only shown in a front-end dashboard table in a dax formula.  Is this possible?

Thanks again!