How to add calculated measure with specific conditions?

[slavisha84]

Hello, 
I have a dataframe that looks like this:

Using this data I created matrix visual that looks like this:

So basically I have dates with brands and products for authorized sellers and I am displaying the prices for their products. 
Now, there is a column called MAP which is the price that the manufacturer set. W

What i need to do is:

1. Create a measure that will add the Map price for particular product

2. Create conditional formating for every Seller column that will turn their price red font or red background if their prices are different than what MAP is suggesting. 

So basically we adding one more column that will be called Map which is just a measure to display what is the value by the manufacturer for that particular day for a particular product that all sellers would respect. If the seller does not respect then I want to flag the price for a particular product and its particular value. 

What would be the easiest way to go about this?

Data and Pbix. file can be downloaded from here: https://1drv.ms/u/s!AhhZq1add5YwjocEpDT1_TXJ-kbrAQ?e=ekcY4c

[MahyarTF]

Hi,

Add the Measure Column to your table as below :

Color = if ( Data[MAP] <> Data[ Price ], "#F06514")

Then add this column as a Background color to your visual :

Appreciate for Kudos

[slavisha84]

Hi there, 

Thank you for your response MahyarTF. 

I don't think I understand how you did this. 

Add the Measure Column to your table as below :

Color = if ( Data[MAP] <> Data[ Price ], "#F06514")

Do you think add the Measure, or Add column?

Also, how did you add it to the background color of the visual?

[MahyarTF · Accepted solution]

Hi,

My wrong,

Add the Column to your table :

Then in your Matrix Visual, go to the Format Pane, and then in "Cell elements", enable the 'Background color' :

then click on "FX", then do as below :

[slavisha84]

Thank you so much for elaborating the answer. I think i got it now.  🙂