How to calculate the percentage of slicer selected total over grand total (selected and not selected

[Anonymous]

I wonder if anyone ever needs to calculate the percentage of sales/cost/production of the selected customer/style/group over the grand total (selected and unselected).

In the example below:

For sales date from 1/1/2018 to 1/30/2018, customer AAA and BBB should count for 75% of total sales (2160/2880)

The end result would be a measure that can be put in an enhanced text display card showing:

So in short, the numerator should interact with the filter while the denominator should not interact with the filter.

I could not find a post with a similar question and have tried several ways but no luck so far.

I have created a test file but I'm not sure how to upload it... here is a link:

https://1drv.ms/u/s!AioBq1-tCi_vlVYHUpXsu5-Mc4Hh

I would really appreciate the help!

Thank you!

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[Anonymous · Accepted solution]

There are two ways to this problem:

1. Measure = [Quantity sold]/CALCULATE([Quantity sold],ALLEXCEPT('Table','Table'[Sales Date]))

2. Measure = [Quantity sold]/CALCULATE([Quantity sold],ALL('Table'[Style]),ALL('Table'[Customer])) - contributed by Ashish_Mathur

Thank you!!

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[Anonymous]

Thank you for sharing this!

[Anonymous]

Thank you so much Ashish! 

[Ashish_Mathur]

You are welcome.

[Anonymous]

My friend at work tried this:

= SUM('Table'[Sales Qty]) / CALCULATE(SUM('Table'[Sales Qty]),ALL('Table'))

but this ends up ignoring the date filter as well... 

Anyone know how to make it include everything except the date?

Thank you!