Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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.
Hi,
Assuming Price-1 is a measure, write this measure
Measure-1 = if(max(Product_master[Product])="ABC",[Price-1],blank())
Hope this helps.
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
60 | |
55 |
User | Count |
---|---|
183 | |
111 | |
105 | |
77 | |
70 |