Forum Discussion

RMV's avatar
RMV
Helper V
8 years ago
Solved

combined table

Hi,   I'm trying to find a smarter way to create 1 table, to combine 2 types of calculation, i.e. a sum of a category & a result from a measured column. For example: sum of Category A = 1000 (whi...
Need Help
  • v-haibl-msft's avatar
    v-haibl-msft
    8 years ago

    RMV

     

    We used calculated columns to get the desired table, so using slicer here is not work as expected, unless we use calculated measure.

    But using calculate measures, we will not be able to get the desired table format, the only way is to use two table visuals.

     

    Best Regards,
    Herbert

RMV's avatar
RMV
Helper V
8 years ago

Hi v-haibl-msft,

 

This is awesome. I got the concept & managed to create the format.

However, I faced another challenge.

I have 2 slicers from the raw data table, i.e. Table 1 in this example, i.e. entity & month.

Need a further advise, how can I link the slicers to the new table?

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
8 years ago

RMV

 

We used calculated columns to get the desired table, so using slicer here is not work as expected, unless we use calculated measure.

But using calculate measures, we will not be able to get the desired table format, the only way is to use two table visuals.

 

Best Regards,
Herbert

  • RMV's avatar
    RMV
    Helper V
    8 years ago

    Hi v-haibl-msft,

    Thanks for the explanation.

    It's not what I expected, since it took an amount of time to do the setting (for example format, interactions, etc)

    But, I can live with separated tables for now :smileyhappy:

    Thanks again.