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,
i created a measure to countrow dax in my dashboard.It works but not in the Total. Do i miss anything in the DAX?
DAX:
You probably want different aggregation depending on the column, but you can use this same pattern. Not sure what your other Row header column name is.
MeasureToGetCorrectTotals = SUMX(SUMMARIZE(Table, Table[Plant Code], Table[Other Column Used in Row]), [Your Existing Measure])
You can use AVERAGEX instead of SUMX to (e.g., like for percentage measure). Make this measures referencing your existing measures and then used the new ones to replace the existing ones in your visual. You should get correct #s on the rows and in the totals.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |