Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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 January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
15 | |
11 | |
8 | |
8 | |
8 |
User | Count |
---|---|
22 | |
13 | |
11 | |
10 | |
10 |