Forum Discussion
Matrix Lower Level format duplication to blank
So I am looking at financials. Budget [BUDGET TOTAL COST] vs Actual info. My actual info is split between Purchase orders [PO TOTAL COST], Material Orders [ MO TOTALPRICE] and Journal adjustments [JC ActualCost],
This is the high level unexpanded view,
and this is expanded with duplicate values from the JC actual cost. There is no relation between JC ACTUALCOST and the PO field so I understand why they show up as duplicates BUT I would just like to display those as blank or zero instead of a never ending tarade of duplicate values.
Hi Andries
If you have tables and create relationships below,
If you add [cate1] from "actual1" table, [actual2] and [budget] from other tables have no corresponding values for [cate1],
then you can create measure below to replace original columns
Measure actual 2 = IF(ISINSCOPE(actual1[cate1]),BLANK(),SUM(actual2[actual2]))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.
2 Replies
Hi Andries
If you have tables and create relationships below,
If you add [cate1] from "actual1" table, [actual2] and [budget] from other tables have no corresponding values for [cate1],
then you can create measure below to replace original columns
Measure actual 2 = IF(ISINSCOPE(actual1[cate1]),BLANK(),SUM(actual2[actual2]))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.v-juanli-msft This worked really well. Just one question, my total values dissapear when I expand.
CollapsedExpanded
Your demo still shows them? How do I show mine as well.
