Subtotal and total not showing

ViktorJ — Wed, 05 Jul 2023 12:38:16 GMT

Hi all,

I get values in the rows, but no values in the subtotal or total. I need the subtotals and total to be the average of the values.

I have the following DAX:

Volume compliance (on archetype level) =

VAR NoOfMetrics = 2

VAR VolumeCon =

AVERAGEX('SiteSnaphot Volume', ([CBM - Inbound (%)] + [CBM - outbound (%)]) / NoOfMetrics)

VAR VolumeDecon =

AVERAGEX('SiteSnaphot Volume', ([Cartons - Inbound (%)] + [Cartons - outbound (%)]) / NoOfMetrics)

VAR VolumeFul =

AVERAGEX('SiteSnaphot Volume', ([Units - Inbound (%)] + [Units - outbound (%)]) / NoOfMetrics)

RETURN

SWITCH(SELECTEDVALUE('SiteSnaphot Volume'[ArcheType]),

"Consolidation", VolumeCon,

"Deconsolidation", VolumeDecon,

"Fulfilment", VolumeFul)

Furthermore, if you have a solution on how I can make the VolumeCon etc. more dynamic that dividing with 2.

This is a snip of the subtotal (upper white cell with no value) and row value (blue cell with 100%).

Furthermore, the [CBM - Inbound (%)] etc. are measures that I have created.

Hope you can help me.

Viktor

Re: Subtotal and total not showing

lbendlin — Sun, 09 Jul 2023 18:06:19 GMT

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523