SUM existing measures that are based on different filters

[melanie-g]

Hi there

Not sure if this is possible, but I want to create a measure to SUM the total gross column.

Although my screenshot looks like the information shown is in one matrix, it is not, each line is a separate matrix.

(Note: I did this because I wasn't sure of any other way to do it based on my current knowledge level, and because the data required is from multiple tables from our datawarehouse and there is no key identifier to link them at this stage).

So my issue is, the Total Gross for each department is calculated differently and has a separate measure for each. 

When I create a new measure for Operating Gross to sum the individual Total Gross amounts,  the incorrect result is being produced. I have ensured all the same filters apply and still don't get the right result.

Is there any way to do this? 

Thank you.

Melanie

[Anonymous · Accepted solution]

Hi @melanie-g ,

It seems that the total value of measure is not correct, right? This document has a detailed explanation.

Please refer to.

Dealing with Measure Totals 

I have also create a simple sample, please refer to it to see if it helps you.

Measure_2 =
VAR _A =
    SUMMARIZE ( 'Table', 'Table'[suject], "AAA", [Measure] )
RETURN
    IF ( ISINSCOPE ( 'Table'[suject] ), [Measure], SUMX ( _A, [AAA] ) )

If I have misunderstood your meaning, please provide more details with your desired output and pbix file without privacy information (Or some sample data).

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.