topic Re: DAX function in DAX Commands and Tips

DAX function

Anonymous — Tue, 15 Feb 2022 18:04:05 GMT

Hi,

I need to calculate "how many items dispatched during the last iteration?" to vizual in a card.

As above shown, I need to get the total count in particular iteration, where the end time is last and type=Dispacher.

eg: In the above shown, as the last end time is 10:23:27 PM where the type is Dispacher, the output should be the count in iteration id=2, which is 8.

Re: DAX function

ValtteriN — Tue, 15 Feb 2022 18:58:09 GMT

Hi,

Try this kind of logic:

measure =
Var latestDispatch = CALCULATE(MAX(Table[End Time]),ALL(Table),Table[Type]="Dispatcher")
Var lastestIteration = CALCULATE(MAX(Table[Iteration ID]),ALL(Table),Table[End Time]=latestDispatch)
Return
COUNTROWS(FILTER(ALL(Table),Table[Iteration ID]=lastestIteration))

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/