Forum Discussion
Displaying Consistent Row-Level Total in Power BI Table
Hello everyone! Glad to be here. I'm having a few questions, hope someone could guide me. In my mind this is not supposed to be hard, but somehow I find it tricky. What I want is to create a me...
Hi,
This pattern should work
- Create a Calendar Table with calculated column formulas for Year, Month name and Month number. Sort the Month name by the Month number
- Create a relationship (Many to One and Single) from the Date column of the Data Table to the Date column of the Calendar Table
- Drag Year from the Calendar Table to the slicer and select 2021
- To your matrix visual, drag Month name from the Calendar Table
- Write these measures
Total = sum(Data[Sales])
Total of all months = calculate([Total],all(Calendar[Month name]))
Average = divide([Total of all months],12)
Hope this helps.
Thanks for the assistance Ashish. I followed up every single step, but at the end it managed to keep the same number on each row but failed to sum correctly. However, this is the first time I try this approach of creating a Calendar Table and I find it interesting, so maybe I did something wrong but definitely going to try this approach again in the future.