Forum Discussion
Aggregation changes when conditional column is added to a matrix visual
Hi Community Experts,
I have a matrix visual which contains columns from multiple tables and a calculated measure.(sum)
The calculated measure gives the result correctly but when i add a conditional column, this measure (sum) splitts into partial sum which I don't need.
Would you please advise how to solve the issue?
Without conditional column
Column A Column B Measure
A 1 50
A 2 50
B 1 60
B 2 60
B 3 60
But when I add a conditional column, it show like this
Column A Column B Measure conditional column
A 1 20
A 2 30
B 1 10
B 2 8
B 3 42
Appriciate your help
Problem is solved. I used First(conditional coulum) in matrix visual.
Column A Column B measure First of conditional column
Thanks!!
2 Replies
- RaazHelper II
Problem is solved. I used First(conditional coulum) in matrix visual.
Column A Column B measure First of conditional column
Thanks!!
- v-frfei-msftCommunity Support