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, have tried to read the board here and get a % of subtotal to work correctly. Below is an image of my Dax formula. I do have filters applied in the filters pane. Is that why my formula does not work? So if I have Filter A = This and Filter B = That and they do not show on the matrix itself, do I have to include that in my formula? It almost seems as if the calculation is being done on all records in the table, not just my filtered records. TIA!
@Razorbx13 , Try a measure like
divide(sum('GL Transaction'[Amount]), calculate(sum('GL Transaction'[Amount]), filter(AllSelected('GL Transaction'), 'GL Transaction'[Account Group] = Max('GL Transaction'[Account Group]))))
Did I miss something?
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 |
---|---|
41 | |
20 | |
19 | |
15 | |
15 |
User | Count |
---|---|
46 | |
28 | |
25 | |
18 | |
17 |