Measure, Total & Subtotals

lallaonline — Tue, 28 Apr 2020 16:10:55 GMT

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

Re: Measure, Total & Subtotals

Anonymous — Thu, 07 May 2020 00:21:33 GMT

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

topic Measure, Total & Subtotals in DAX Commands and Tips

Measure, Total & Subtotals

Re: Measure, Total & Subtotals