Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello Mates,
Hope everyone's doing well.
I have one requirement where I want to select multiple measures from Slicers selection. For that I have create the belo tables and Dax.
But I am not able to select it and its throwning me below error msg.
So please help looking for urgent help !
Thank you in advance.
Regards,
Dev
Hi @Anonymous,
Switch function is possible to setting multiple cases to return different expressions. (these expressions can from different measures) Notice: it not able to handle summarize results such as selecting multiple conditions at the same time. (for this scenario, it not trigger any conditions)
If your scenario requires to handle multiple selections, I think you need to do some modifications with summarized row contents.
Regards,
Xiaoxin Sheng
@Anonymous , what should happen when you select two values?? You should consider only one
Measure Selection = SWITCH( TRUE(),
MAX(DimMeasure[Measure]) = "Last 7 Days", [Clicks Last 7 Days],
MAX(DimMeasure[Measure]) = "Last 30 Days", [Clicks Last 30 days],
MAX(DimMeasure[Measure]) = "Last Quarter", [Clicks Last Quarter Days],
MAX(DimMeasure[Measure]) = "Previous Period", [Clicks Previous Period],
MAX(DimMeasure[Measure]) = "Same Period Last Year", [Clicks Same Period Last Year],
BLANK())
Hey @amitchandak
Thank you for your quick reply.
Here, I want to show atleast two comparision by selecting two slicer filter. So is this possible ?
Thanks,
Devanand
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |