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 all,
I see that there is no countif in PowerBI.
Is there an alternative?
In excel I have applied the formula '=COUNTIF(B6:CN6,">0")'
In PowerBI I am not sure on how to do it.
Can I know how to implement that?
Any help is appreciated!
Thank you!
Megha
Solved! Go to Solution.
Hi @Anonymous ,
Create a measure like this
Please accept this as a solution if your question has been answered !!
Appreciate a Kudos 😀
Connect with me on LinkedIn: https://www.linkedin.com/in/jaideepnema/
Hello:
The COUNTIF in DAX can be done several ways. It depends on how you set up your model and what tables relate to eachother.
If you only have a single table it can also be handled with this:
Hi @Anonymous ,
Create a measure like this
Please accept this as a solution if your question has been answered !!
Appreciate a Kudos 😀
Connect with me on LinkedIn: https://www.linkedin.com/in/jaideepnema/
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |