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 All,
My scenarion:
- I have fully customized matrix
- I would like to keep sum of values in the measures
- I would like to assign measures to the customized matrix using SWITCH function
Problem:
- I have difficulties to make some mathematical calculation in measueres and based on the measures
Theare my measures
Gross Margin Level (CURR) is represent value in case of direct assignment to seperate matrix but doesn't work with SWITCH function
Please check the following pictures to see the result I would like to obtain
Thank you in advance for you reply.
Hi @Anonymous
First, returning a mixture of data types from a measure is a VERY BAD idea. Refrain from doing this or you'll suffer rather sooner than later. You should not return an empty string "" from the SWITCH measure. Just remove the piece from the formula and DAX will automatically return BLANK if no option out of the list is selected, which is the correct thing to do. It might even fix your problem...
Hello @Anonymous
Can you return some text instead of "" values? Check if it's working fine.
Can you please share some sample data after removing sensitive information?
with text instead of values works well.
Hey @Anonymous
Can you please share your pbix file after removing the sensitive information?
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 |
---|---|
38 | |
26 | |
20 | |
15 | |
8 |
User | Count |
---|---|
71 | |
47 | |
46 | |
20 | |
16 |