Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
There are multiple ways to do this, here is one: Create a new measure
There are multiple ways to do this, here is one: Create a new measure
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]))
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))
Quarter | Brand | Region | Sales (NBR CARS) | ||||
1 | Nissan | lyon | 14 | lyon | Paris | ||
1 | Nissan | Paris | 30 | 32% | 68% |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |