Zebra BI combo chart grand total column does not show second measure

[Anonymous]

I have sales data per month shown on Zebra BI combo chart with current and last year data. For values where I placed current year sales data I also have second measure for gross margin %.

When I turn on Grand Total column to display running total YTD it only displays sales data but not GM%. Is there any way I can also present YTD GM% together with sales data in Grand Total column? Doesn't seem to work out of the box.  Currently it shows GM% for each month but not in Grand Total column.

Thanks!

[v-alq-msft · Accepted solution]

Hi, @Anonymous 

Based on your description, I created data to reproduce your scenraio. The pbix file is attached in the end.

Table:

You may create measures as below.

Sales Measure = SUM('Table'[Sales])

GM% Measure = 
DIVIDE(
    SUM('Table'[Sales])-SUM('Table'[Cost]),
    SUM('Table'[Cost])
)

Sales YTD = 
var st = 
CALCULATE(
    MIN('Table'[YearMonth]),
    FILTER(
        ALL('Table'),
        [Year] in DISTINCT('Table'[Year])
    )
)
return
CALCULATE(
    SUM('Table'[Sales]),
    FILTER(
        ALL('Table'),
        [YearMonth]>=st&&
        [YearMonth]<=MAX('Table'[YearMonth])
    )
)

GM% YTD = 
var st = 
CALCULATE(
    MIN('Table'[YearMonth]),
    FILTER(
        ALL('Table'),
        [Year] in DISTINCT('Table'[Year])
    )
)
return
SUMX(
    FILTER(
        ALL('Table'),
        [YearMonth]>=st&&
        [YearMonth]<=MAX('Table'[YearMonth])
    ),
    DIVIDE(
        [Sales]-[Cost],
        [Cost]
    )
)

Result:

If I misunderstand your thoughts, please show us some sample data and expected results with OneDrive for business. Do mask sensitive data before uploading. Thanks.

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.