Aggregation changes when conditional column is added to a matrix visual

[Raaz]

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

[Raaz · Accepted solution]

Problem is solved. I used First(conditional coulum) in matrix visual.

Column A    Column B      measure             First of conditional column

Thanks!!

[v-frfei-msft]

Hi @Raaz ,

Thanks for sharing your solution here.