Need a help in creating a measure.

[Anonymous]

Dear Experts

I want to achieve the below result in my measures-1 which should only populate the value corresponding to product is "ABC".

Can someone please let me know what is the formula for this please.

P.S: The product field is coming from a table called product_master and price-1 is a formula which sum up 2 different key figures.

Thanks
Mahad

[Ashish_Mathur · Accepted solution]

Hi,

Assuming Price-1 is a measure, write this measure

Measure-1 = if(max(Product_master[Product])="ABC",[Price-1],blank())

Hope this helps.

[Seanan]

Hi @Anonymous 

You can create 2 custom columns to achieve this.

Please find the example below:

ABC = IF('Sheet1'[CustomA] = "ABC",'Sheet1'[Column1])

DEF = IF('Sheet1'[CustomA] = "DEF",'Sheet1'[CustomB])

 

If this solves your problem, please accept it as the solution.

Kind regards,

Seanan