I added DAX to calculate average of counts for 6 months data in Matrix visual of power Bi. Instead of calculating for the total count average, the DAX is calculating average for each month and added extra columns in my visual. How can i remove those extra columns and display only one total count of average column for 6 months data.
I tried using DAX but it did not work. My expectation is to show only one column for average calculation.
New contributor
Ishi Sri is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.