Measure, Total & Subtotals

[lallaonline]

Hi all,

I'm working on a matrix.

I had a problem with a measure that is correctly calculated but is propagated on subtotals and row details too

Roster data is the tracking of all printing events on every printer, for any  single user. 

I have created a table with budget for any office and costs for black or color pages, and fixed costs. By power query and visual now I have budget per office(PO Amount), list of printers by model, with printers serials list & related calculated costs.

For every order I have calculates single devices, total costs and residual balance (in values and %, but this calculation is propagate on every row).

I need it only for PO(6000...)or PO amouny Total row/aggregate. In yellow what I need to hide(do not consider green by arriving by conditional formatting) to better understand my need

Thnk you

Laura

[Anonymous]

Hi @lallaonline ,

I'm not sure whether I understand your requirement correctly, what you want is only display the summary row record and hide the cost of a single device just like below screen shot? You can remove the single device fields from the matrix Rows fields.

Best Regards

Rena