Showing card value as a percent of total

[Doliveira]

Hi!

I've created 2 cards with different values from the same column according by the date. Follow images for a better undestanding:

              

                 

Assuming that are 19 entries for 05/08/2017, 16 entries as "Atendidas" and 3 entries "Abandonadas", how can I change the card value to percentual of the total (84% Atendidas / 16% Abandonadas) ? 

Tks!

[Anonymous · Accepted solution]

There are multiple ways to do this, here is one: Create a new measure

% of Abandonadas =
VAR Total_of_Abandonadas =
    CALCULATE (
        COUNTA ( Table1[Disposicao do Contato] ),
        Table1[Disposicao do Contato] = "Abandonadas"
    )
RETURN
    DIVIDE ( Total_of_Abandonadas, COUNTA ( Table1[Disposicao do Contato] ) )

Remember, the VAR function just allows you to put all the needed calculations into one measure.  You can just make multiple measures and build them up.  Example:

Build a new measure to get the count of Abandonadas

Total Abandonadas =
    CALCULATE (
        COUNTA ( Table1[Disposicao do Contato] ),
        Table1[Disposicao do Contato] = "Abandonadas"
    )

Then build your % measure: 

  % of Abandonadas = DIVIDE ( Total Abandonadas, COUNTA ( Table1[Disposicao do Contato] ) )

[Doliveira]

Thanks @Anonymous! Using the VAR function solve the problem! But when I change the day that there're no entry of "abandonadas", the card shows (Blank).

How can I upgrade this code to add "ISBLANK" function?

% of Atendidas = VAR Total_of_Atendidas = CALCULATE (COUNTA ('Relatório Detalhado de Chamadas'[Disposição do Contato]);'Relatório Detalhado de Chamadas'[Disposição do Contato] = "Atendidas")

RETURN

    DIVIDE (Total_of_Atendidas; COUNTA ('Relatório Detalhado de Chamadas'[Disposição do Contato]))

[Greg_Deckler]

You should be able to click the drop down on your field and expand "Show value as" and then "Percent of grand total".

If not, then you would need to create a couple measures like:

Attendees = CALCULATE(COUNT([Contado]),FILTER(Table,[Contado]="Attendee")) / CALCULATE(COUNT([Contado]),ALL(Table))

[Anonymous]

Hello @Greg_Deckler 

as a newbie I am faced to same issue. I have tried to create a measure to use in the Card but does not show the proper % . only shows 100% (if I delete the denominator part the right cont of sales is shown, if I add the denominator then only 100% shown)

I have in the page 2 slicers (brand and quarter) and below chart summarizing the Count of sales (not the sum as per my data I need to count the number of sales)

then I need to show the 2 cards on the right (Lyon % of total count & Paris % of total count)

Quarter	Brand	Region	Sales (NBR CARS)
1	Nissan	lyon	14		lyon		Paris
1	Nissan	Paris	30		32%		68%

one of the measures used is here below

Nbr Dsp ref % = divide (CALCULATE ( COUNT ([Sales] ), Filter ('Table', [Region] = "Lyon")), CALCULATE(COUNT([Sales]),ALL('Table')))

appreciate your support