Forum Discussion
Raul
Post Patron
Post PatronTotal different according to a condition
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 colu...
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! 🤠
Ashish_Mathur
Super User
Super UserHi,
Share data in a format that can be pasted in an MS Excel file and show the expected result.