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,
Can anyone help me please...
Try to count
1. List with 100% value
2. Expected value = 8
BUT i got 83
Solved! Go to Solution.
HI @powerbi1986
PFA the file.
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
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))
Hi @powerbi1986
Can you please share the sample pbix file.
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
hi @pranit828
as requested..
The sample PBIX file
https://www.dropbox.com/s/qr8h3k4wdu35cia/SAMPLE.pbix?dl=0
HI @powerbi1986
PFA the file.
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
Hi @pranit828
Why count of the list remain the same after i untick one of the list from filter function?
I havent got 8 yet
Will try
Hi @powerbi1986
I would use the below DAX.
_count100% =
VAR _pcnt = DATA[% (B/A)]
CALCULATE(COUNT(table[LIST]),FILTER(ALLSELECTED(Table[LIST]),_pcnt = 1))
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |