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! 🤠
Daniel29195
Community Champion
Community Champion
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! 🤠
RaulPost Patron
Post PatronThank 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.