Count row with 100% value only

[powerbi1986]

Hi, 

Can anyone help me please...

Try to count 

 1. List with 100% value

 2. Expected value = 8 

BUT i got 83

[powerbi1986]

hi @pranit828 
still the same after using below DAX

_count100% =
VAR _pcnt = DATA[% (B/A)]
CALCULATE(COUNT(table[LIST]),FILTER(ALLSELECTED(Table[LIST]),_pcnt = 1))

[pranit828]

Hi @powerbi1986 

Can you please share the sample pbix file.

[powerbi1986]

hi @pranit828 

as requested..

The sample PBIX file

https://www.dropbox.com/s/qr8h3k4wdu35cia/SAMPLE.pbix?dl=0

[pranit828 · Accepted solution]

HI @powerbi1986 

PFA the file.

[powerbi1986]

Hi @pranit828 

Why count of the list remain the same after i untick one of the list from filter function?

[powerbi1986]

HI @pranit828 

Thanks a lot..

[powerbi1986]

I havent got 8 yet

[powerbi1986]

Will try

[pranit828]

Hi @powerbi1986 

I would use the below DAX.

_count100% =
VAR _pcnt = DATA[% (B/A)]
CALCULATE(COUNT(table[LIST]),FILTER(ALLSELECTED(Table[LIST]),_pcnt = 1))