How to get Total of calculated measure in Power BI desktop

[GayatriB100]

Can anyone let me know how we calculate the total of the measure 'New' shown in below table:

In the above total is getting displayed for 2022 sales and 2021 sales but not for New (which is a calculated measure).I need to show the total also as underline rows would be having data .For ex not all rows will have a new value but some will have and i want to sum them all and show it at publication level.

So here I want the total to display for New column at publication level as (£8505+239328+3686) however it shows nothing it's blank at Canada publication level.Please advice.

[willjoe]

SUM is going to look at the 'Total Sales' column in the 'Sales' table and sum all the values together. Let's use a matrix visual to display the measure 'SUM' by 'ITEMNAME'. To do this, we add 'ITEMNAME' as the row value and 'SUM' as our values in Power BI. Here we can see that SUM does exactly what we expect it to do

Regards,

Will

[GayatriB100]

@willjoe  I am already using the matrix visual and the 'New' measure is part of values and 'Publication' part of rows.It still doesn't work.

[v-yiruan-msft · Accepted solution]

Hi @GayatriB100 ,

Please create another new measure as below and put this new measure onto the matrix visual to replace the original measure [New]. Later check if it can get your expected result.

New measure =
SUMX (
    GROUPBY (
        'Finance Sales',
        'Finance Sales'[Publication],
        'Finance Sales'[Allocated Sales Person]
    ),
    [New]
)

In addition, you can refer the following links to try to solve your problem...

Why Your Total Is Incorrect In Power BI - The Key DAX Concept To Understand

Dax for Power BI: Fixing Incorrect Measure Totals

Best Regards

[GayatriB100]

Thank you @v-yiruan-msft for the help .It works.

[amitchandak]

@GayatriB100 , It would like

Calculate([2022 sales] , filter(Table[publication] in {"Ella Meads","EO", "JA"}))

Use the correct names

[GayatriB100]

Thanks for replying so quickly.

When i use that calculation I am getting this below error:

New Sales at Guide = Calculate([2022 sales] , FILTER('Finance Sales','Finance Sales'[Allocated Sales Person]))

Also I don't want it to hardcode as Table needs to display for each row.So here Publication column have values like Canada,USA,etc and the drill down is at Salesperson level.So I want to sum those salesperson sales and show it at Publication level.