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.
My data is all in columns on the same table-no relationships needed. I need to find the % of projects that have lessons. The screenshot is the excel version of the data output. The excel formula is
=SUBTOTAL(9,Table1[Column1])/SUBTOTAL(3,Table1[Project]).
How can I translate this into DAX?
I tried this, but the % isn't correct (comes up 4.8%).
Solved! Go to Solution.
I figured it out on my own. The answer was simply
Hi @Queen_Geek ,
After my tests, i got the same result with these formula. Maybe it is caused by your filter or slicer. You could add ALL() filter in your measure.
I figured it out on my own. The answer was simply
@Queen_Geek , Not very clear.
Refer if this can help
https://community.powerbi.com/t5/Desktop/Percentage-of-subtotal/td-p/95390
That doesn't help. There are no subtotals in my data, it's in columns, like the screenshot shows. What isn't clear? Here is a screenshot of the data (partial) if that helps?
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 |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |