cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
daxing Frequent Visitor
Frequent Visitor

Working with totals

Hi all, new here and stuck at a situation where I cant figure out how to solve it.

I have a table with the following values, as you would see, the total is 1269. I have created another mesure called "3.1 Total of all status" to calculate the total irrespective of my filter to choose between cheap, same or expensive. So if I choose only cheap, the total in the table will ofcourse show 1026 and my measure would be 1269.

Now the problem is that, if I EXCLUDE cheap and only select same and expensive, my measure shows the total as 1266 which is incorrect, as it should be 1269 irrespective of the filter. Basically its excluding the cheap for MacKay as there are no other values for it from the grand total which I dont want it to do.

 

Here is an example:

 

No filters selected.

 

1.PNG

Measure 3.1 below works fine as it shows 1269 even when if I only choose cheap and same which is correct

 

2.PNG

But now when I choose expensive and same, my measure shows the value as 1266 which is not correct as its also exluding the 3 cheap for MacKay from the total. 

 

3.PNG

 

Please can someone assist? Apologies if i have confused you all!

1 ACCEPTED SOLUTION

Accepted Solutions
v-yulgu-msft Super Contributor
Super Contributor

Re: Working with totals

Hi @daxing,

 

Please use ALL in the formula of "3.1 Total of all status". For more advice, please post the DAX formula you used for 3.1 Total of all status. And it would be better you could share the sample .pbix file for check.

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Super User
Super User

Re: Working with totals

Hi @daxing

 

Can you please share the pbix file so that people can try to find out what the issue is? It's a bit hard without seeing the code for your measures for instance

daxing Frequent Visitor
Frequent Visitor

Re: Working with totals

Sure, I will do so as soon as I get back from work. Thanks
v-yulgu-msft Super Contributor
Super Contributor

Re: Working with totals

Hi @daxing,

 

Please use ALL in the formula of "3.1 Total of all status". For more advice, please post the DAX formula you used for 3.1 Total of all status. And it would be better you could share the sample .pbix file for check.

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 537 members 4,322 guests
Please welcome our newest community members: