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.
Solved! Go to Solution.
You can use the CALCULATE function to count filtered values.
Male %age = CALCULATE(Count([sex]),[sex] = "Male") / Count([sex])
Have you tried the latest version of PBI Desktop ? see below:
Hi @samcaicn,
The MALE is a calculated column? The synax of COUNTROWS function is COUNTROWS(<table>). Why you use column rather than table? Why you use Could you please share the complete DAX and your sample data for further analysis? So we can post the solution which is close your requirement. It's hard to reproduce your scenario. Thanks for understanding.
Best Regards,
Angelia
You can use the CALCULATE function to count filtered values.
Male %age = CALCULATE(Count([sex]),[sex] = "Male") / Count([sex])
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |