Forum Discussion

cvaldez96's avatar
cvaldez96
New Member
2 years ago
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...
Need Help
Tutorial Requests
  • cvaldez96's avatar
    cvaldez96
    2 years ago

    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/

     

cvaldez96's avatar
cvaldez96
New Member
2 years ago

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/