Forum Discussion
Solved
Count row with 100% value only
Hi,
Can anyone help me please...
Try to count
1. List with 100% value
2. Expected value = 8
BUT i got 83
9 Replies
Hi powerbi1986
I would use the below DAX.
_count100% =
VAR _pcnt = DATA[% (B/A)]
CALCULATE(COUNT(table[LIST]),FILTER(ALLSELECTED(Table[LIST]),_pcnt = 1))I havent got 8 yet
Will try
hi Anonymous
still the same after using below DAX_count100% =
VAR _pcnt = DATA[% (B/A)]
CALCULATE(COUNT(table[LIST]),FILTER(ALLSELECTED(Table[LIST]),_pcnt = 1))Hi powerbi1986
Can you please share the sample pbix file.
hi Anonymous
as requested..
The sample PBIX file
https://www.dropbox.com/s/qr8h3k4wdu35cia/SAMPLE.pbix?dl=0
