Forum Discussion
Subtotal and total not showing
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
1 Reply
- lbendlin
Super User
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
