cancel
Showing results for
Did you mean:
Highlighted
Helper V

## 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 (which is a sum from the raw data)

sum of Category B = 900 (which is a sum from the raw data)

Gap = 100 (which is returned from a measured column (Gap = SUM([Category A]) + SUM([Category B])

The table result is suppose to look like this:

 Total Average Category A 1000 110 Category B 900 95 Gap 100 15

Now, have 2 separate tables for Category A & Category B total & average, and another table for the Gap measured total & average.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft

## Re: combined table

@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

4 REPLIES 4
Highlighted
Microsoft

## Re: combined table

@RMV

In such scenario, we may need to create another table and some calculated columns as a trick.

The new created table needs to have a column which includes Category A, B, and Gap like following screenshot. Then we can use IF function to do the desired calculations.

For details, please refer to attached PBIX file.

Best Regards,
Herbert

Highlighted
Helper V

## Re: combined table

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?

Highlighted
Microsoft

## Re: combined table

@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

Highlighted
Helper V

## Re: combined table

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

Thanks again.

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

#### Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors