Forum Discussion

felipetrin's avatar
felipetrin
Regular Visitor
5 years ago

Running count total by month (IMPOSSIBLE?)

Hello everyone!

 

To summarize my infos:
WHAT I HAVE: A database that shows when (DATE) a new machine (MACHINE) was added in my mini factoty and its level of importance (LEVEL OF IMPORTANCE) [Check out the picture in the end of this post].

WHAT I WANT: I want to check out the evolution of my machines in my mini factory detailing it by level of importance according when they were bought (DATE) [Check out the picture in the end of this post].

WHAT I'VE TRIED: I've tried this DAX Measure:

Measure =
CALCULATE(
     COUNTROWS(Table),
     FILTER(
          ALL(Table),
          Table[Date] <= MAX(Table[Date])
     )
)

PICTURE:

Picture:

 

Thanks for helping me!

COUNT
running

1 Reply

  • stevedep's avatar
    stevedep
    Memorable Member
    5 years ago

    Hi,

     

    The code below should do the trick.

     

    _RT = 
var _no = CALCULATE(DISTINCTCOUNT(NewTable[i]), ALL(NewTable[i]))
return
COUNTROWS(FILTER(ALL(NewTable), NewTable[imp] = SELECTEDVALUE(NewTable[i]) && [date] <= MAX(NewTable[date]))) / _no

     

    It does require you to transform your table / add a new version of it:

     

    NewTable = CROSSJOIN(SELECTCOLUMNS(VALUES('Table'[imp]),"i", [imp]),'Table')

     

    In this video I show how to create the dashboard as seen below.

     

     

    Link to the file here. 

    Pls mark as solution if so. Thumbs up for the effort are appreciated.

    Kind regards, 

    Steve.