Displaying greater detail where there are relationships with only some of your data

[Anonymous]

Good afternoon all!

I currently have a report which is a summary of a number of other reports where by almost every line is consolidated into a single line-

behind the PURCHASES JOURNAL line, there are a number of other lines that make up this figure per the below-

Is there a way of substituting this single line that says PURCHASES JOURNAL for the lines that make up that figure, so EXPENSES and NATWEST CREDIT CARD whilst maintaining the other two lines which have no relationship to the detail in the PURCHASES JOURNAL report please?

Thanks in advance!

[v-juanli-msft]

Hi @Anonymous 

Here is a simple test:

If i want "ba","bb" under travel b show sum of its own value and aa, ab value

I could use this meausre

aa = CALCULATE([m_value],FILTER(ALL(Table1),Table1[travel]="a"&&Table1[cate]="aa"))

ab = CALCULATE([m_value],FILTER(ALL(Table1),Table1[travel]="a"&&Table1[cate]="ab"))

final value = IF(ISINSCOPE(Table1[cate]),IF(MAX(Table1[travel])="b",[m_value]+[aa]+[ab],[m_value]),[m_value])

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.