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, and thanks for any help. Over the last couple months I've had the opportunity to start editing dashboards at work and am really enjoying it and want to keep pursuing the skill.
I'm trying to create a new measure, that looks at two separate columns, in separate tables.
This is what I have so far and am getting the "too few arguments passed to the divide function error"
Solved! Go to Solution.
Hello @tcouey ,
Please use below measure to fix your error-
MRC Controls as % of Total Issues = DIVIDE(Countx(Filter(Controls,controls[mrc_control] = "Y"),controls[id]), count(test_issues[id]),BLANK())
If that dont gives you expected results please share sample data and expected output in tabular format.
Hello @tcouey ,
Please use below measure to fix your error-
MRC Controls as % of Total Issues = DIVIDE(Countx(Filter(Controls,controls[mrc_control] = "Y"),controls[id]), count(test_issues[id]),BLANK())
If that dont gives you expected results please share sample data and expected output in tabular format.
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |