Total different according to a condition

[Raul]

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

[Ashish_Mathur]

Hi,

Share data in a format that can be pasted in an MS Excel file and show the expected result.

[Daniel29195 · Accepted solution]

@Raul 

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! 🤠

[Raul]

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.