% of grand total in a Card type visual

[Vtomsons]

Iam creating a dashboard for very specific categories and I can filter out the values that I only want to capture so I get the value with no calculation but I'd like to also show what the percent of the total value would be compared to the entire population.

For example, I have 3 registered students out of 100 we sent a promo email to. I'd also like to show this value as a percentage of 3% in another visual like a card.

I use the count of total unique emails but since I filter all the one's out that I don't want, the card reports the value as 100% when I want it to take in to consideration all the filter totals in to the equation. 

Is this a simple oversight or do I have to set my data up differently?

Thanks,

Val

[v-zhenbw-msft]

Hi @Vtomsons ,

Did @camargos88  solve your issue?

If yes, please kindly mark it as a solution to help others find it more quickly.

If it doesn’t meet your requirement, could you please provide a mockup sample based on fake data or describe the fields of each tables?

It will be helpful if you can show us the exact expected result based on the tables.

Please upload your files to OneDrive For Business and share the link here. Please don't contain any Confidential Information or Real data in your reply.

Best regards,

Community Support Team _ zhenbw

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

[camargos88 · Accepted solution]

@Vtomsons ,

You can use the ALLSELECT/ALL function to ignore the applied filters and calculate the grand total.

Something like:

GT = 
DIVIDE(
SUM(TABLE[COLUMN]),
CALCULATE(SUM(TABLE[COLUMN]), ALLSELECT(TABLE)))

OR

GT = 
DIVIDE(
SUM(TABLE[COLUMN]),
CALCULATE(SUM(TABLE[COLUMN]), ALL(TABLE[COLUMN)))

https://docs.microsoft.com/en-us/dax/allselected-function-dax

https://docs.microsoft.com/en-us/dax/allexcept-function-dax

https://docs.microsoft.com/en-us/dax/all-function-dax