Show the percentage value of a cell in a card

[SAGUILAR]

Hello, community.

Please, I'm trying to show the % value of "RECEIVED, POSTED" status in one card. I created the card using the same columns but when I filter the status, the result show "100%" not "29.16%"

This is the result of the card I created after filtered.

Thanks!

[v-tangjie-msft · Accepted solution]

Hi @SAGUILAR ,

According to your description, here are my steps you can follow as a solution.

(1) This is my test data. 

(2) We can create a measure. 

% count = 
var _a=COUNTROWS(ALL('Table'))
var _b=COUNTROWS(FILTER(ALL('Table'),'Table'[status]=MAX('Table'[status])))
return DIVIDE(_b,_a,0)

(3) Then the result is as follows.

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

Best Regards,

Neeko Tang

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

[NishPatel]

Select the Card visual and apply Status filter only to this visual and Select desired status.

[SAGUILAR]

Hello, 
I've been trying to do it but I'm still getting the same number. Something that I see is that when I remove the option "Show as percentage of total" the number will be correct (571).

Thank you!

[Kishore_KVN]

Hello @SAGUILAR , 

Its happening because when you select a particular value it will always show 100% for that value. So you have to create a measure for it. 

Measure looks as below:

% Contribution = 
Var Num = Calculate(SUM(Sales))
Var Den = Calculate(SUM(Sales),ALLSELECTED(STATUS))
Return
DIVIDE(Num,Den,Blank())

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