how to display row total percentage in card

[vishalmaran06]

 i want 43.30% to display in card visual.. how to do that 

im using this code [Count Rejections] / CALCULATE([Count Rejections],ALL(o_pallet_rejection[Item])) ,  but it giving column percentage

[PhilipTreacy]

Hi @vishalmaran06 

You aren't doing everything the same as me.

Your measure to count rejections is 

Count Rejections = DISTINCTCOUNTNOBLANK(o_pallet_rejection[Rejected Entries])

Mine is

Count Rejections = COUNT(O_PALLET_REJECTION[Rejection])

When I use your code in my data I get the result 1.  When I use mine i get 25, so our data is clearly different.

Really hard to help you when I don't have all the data in front of me, I have to guess what your data looks like.

You can PM me a private link to the PBIX file if you like.

Phil

[PhilipTreacy]

Hi @vishalmaran06 

Have you looked at my file to see if you are doing everything the same as I am?

For example, how are you calculating [Count Rejections] ?

This is how I'm doing it

Count Rejections = COUNT(O_PALLET_REJECTION[Rejection])

If this measure is giving you 100%

Measure = DIVIDE([Count Rejections],CALCULATE([Count Rejections],ALL(o_pallet_rejection[Item])))

then it means that [Count Rejections] and CALCULATE([Count Rejections],ALL(o_pallet_rejection[Item])) are giving the same value, when [Count Rejections] should be smaller when calculated for each Item.

What does your source data table look like?

Regards

Phil

[vishalmaran06]

Im doing same as you done in you pbix file. Count rejection im having diffeerent values only.

im using this for Count Rejections = DISTINCTCOUNTNOBLANK(o_pallet_rejection[Rejected Entries])

Measure = DIVIDE([Count Rejections],CALCULATE([Count Rejections],ALL(o_pallet_rejection[Item])))

Measure 2 = MAXX(o_pallet_rejection,[Measure])

in matrix table showing correctly , but in card showing wronly.

any other method how to get that 43.13% to display it in card

[PhilipTreacy]

Hi @vishalmaran06 

Can you share your PBIX file please?

Phil

[vishalmaran06]

I cant able to share that file, currently im doing project on that pbix file..

Any other idea how to take that row percentage 43.30% and to display it in card.

[PhilipTreacy]

@vishalmaran06 

Download example PBIX file

I think there's more to this than what you've said.  If you just want 43.3% in a card then create a measure that = 43.3%.

So why 43.3%?  Do you actually want the largest % - which is 43.4% in your table?

If so then create a new measure and display this in your card

Max Rejection % = MAXX('O_PALLET_REJECTION', [%GT Count Rejections])

Regards

Phil

[vishalmaran06]

Hi Phil,

for me its showing 100% only, i want to display the maximum percentage in card visual.
i created measure i like you

Measure = DIVIDE([Count Rejections],CALCULATE([Count Rejections],ALL(o_pallet_rejection[Item])))

Measure 2 = MAXX(o_pallet_rejection,[Measure])

but if put it in matrix table (measure) is showing correctly

the issue is in matrix table showing correct value 43%, but in card  its showing 100%