Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
25 | |
12 | |
9 | |
9 | |
9 |
User | Count |
---|---|
21 | |
14 | |
14 | |
13 | |
13 |