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.
Hello community.
I have a matrix where I present by rows the Year and Month of the calendar table and I have also a segmenter by Customer. I want to create a measure that returns the sum of the column Total1 of the table RESULTS if the customer code of that table is equal to 150 or that returns the sum of the column Total1 of the table COMPARISON otherwise.
The CALENDAR and CUSTOMER tables are related to the RESULTS and COMPARISON tables.
What would be the DAX expression of the measure?
Thank you
Solved! Go to Solution.
use the following measue :
measure =
sumx(
values(customer[customer_code]),
switch(
true(),
customer[customer_code] = 150 , calculate ( sum(results[total1]),
calculate ( sum(comparison[total1]))
)
)
let me know if this works for you .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
Hi,
Share data in a format that can be pasted in an MS Excel file and show the expected result.
use the following measue :
measure =
sumx(
values(customer[customer_code]),
switch(
true(),
customer[customer_code] = 150 , calculate ( sum(results[total1]),
calculate ( sum(comparison[total1]))
)
)
let me know if this works for you .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
Thank you @Daniel29195 for your post.
This solution doesn't work in my case because I had to add some other condition but it has helped me to see how to build the measure I needed.
Thank you very much.
User | Count |
---|---|
83 | |
77 | |
71 | |
69 | |
53 |
User | Count |
---|---|
105 | |
100 | |
91 | |
79 | |
68 |