Forum Discussion

Raaz's avatar
Raaz
Helper II
6 years ago
Solved

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

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

     

    Column A    Column B      measure             First of conditional column

     

    Thanks!!