The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
I've two measures Sales and Profit, but I want to create a dynamic parameter for sales and profit, how can I do it?
Regards,
Akhilesh Gupta
Solved! Go to Solution.
Measure =
var selecteditem = MAX(Slicer[Slicer])
return if(selecteditem="Sales",MAX(Sales[Sales]),MAX(Sales[Sales])-MAX(Sales[Cost]))
change MAX to SUM
Measure =
var selecteditem = MAX(Slicer[Slicer])
return if(selecteditem="Sales",SUM(Sales[Sales]),SUM(Sales[Sales])-SUM(Sales[Cost]))
Regards,
Charlie Liao
I have tested it on my local environemnt, the steps below are for you reference.
Regards,
Chalrie Liao
Hello Chalrie Liao,
I used the logic several times, which I got from you, but not working and showing the below error in screenshot.....
Please suggest and how can do it.
Regards,
Akhilesh Gupta
Hello Charlie Liao,
Thanks for the quick response.
The grand total is not matching for Profit and Sales, which I got the solution from you.
Regards,
Akhilesh Gupta
Measure =
var selecteditem = MAX(Slicer[Slicer])
return if(selecteditem="Sales",MAX(Sales[Sales]),MAX(Sales[Sales])-MAX(Sales[Cost]))
change MAX to SUM
Measure =
var selecteditem = MAX(Slicer[Slicer])
return if(selecteditem="Sales",SUM(Sales[Sales]),SUM(Sales[Sales])-SUM(Sales[Cost]))
Regards,
Charlie Liao
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
264 | |
120 | |
115 | |
83 | |
70 |