Forum Discussion
Solved
Help with showing counts without summing or using MAX?
Honestly, I have no idea if this is possible but would like to see if anyone has any solutions. I have a matrix and a bar graph showing counts of vehicles by month and year and I have them filtered b...
Figured it out!
Vehicle Count Branch =LASTNONBLANKVALUE('AF Miles Vehicles'[Month], SUM('AF Miles Vehicles'[Count of Vehicle]))I used this calculation using the month number to sort by and then the sum as my second parameter. I used this page for help : https://exceleratorbi.com.au/lastnonblank-explained/
Just wanted to give some more information
April had less vehicles than March but when collapsing the matrix, it used March's value since it was the max value. But after using my formula above:
It is now taking April's vehicle count as the last non blank value.
And when I select all my branches, it adds up each branch's last value calculating the total!