Forum Discussion
Helper IISUM based on month
Super UserHi Gumberculeez ,
Calculations in PowerBI (DAX) are made based on context, so looking at your print screen the information you have on your data is AccountName and Total so for calculation of the sum of Total the only context is the AccountName so what happens is that the final result is the total for all the values of AccountName.
If you want to have the calculation per month you need to also add the date to the visual in order to get the context of the month.
When you select the Don't summarize option what you are asking is to return the full data for Total column that's why you see all the information per month, again, this is the context that you are giving to your data in this case to not summarize your information with an aggregator.
If you need any further assistance or explanation please tell me.
Regards,
MFelix
GumberculeezThanks for that :)... helping a bit. My underlying issue remains however.
When pick a specific account number it filters only those transactions, however, the total at the bottom remains the overall total for the month.
I'd like only the filtered number total to appear.
- MFelix
- Gumberculeez
I'd prefer to not... It's our business system live data. I can share some screenshots however :). This Account total is a single invoice, and really... the total and the sum'd total (in this case should match). they do not however.