Forum Discussion
Measure with IF statement causes cross join
I have a table visual. I've created a simple measure: Total_participants=CALCULATE(MAX('FactTable'[NB_PARTICIPANTS])) When adding this measure to the visual, the number of rows is correct aka one ...
Anonymous if you will not succeed please mention me here tomorrow, and I'll try to do a quick zoom with you together to see your model exactly.
Anonymous also, please watch this great video:
https://www.youtube.com/watch?v=_cT9PB72fu8
maybe the clue to your solution is here 🙂