Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to Solution.
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/
Proud to be a Super User!
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/
Proud to be a Super User!
User | Count |
---|---|
53 | |
45 | |
19 | |
16 | |
14 |
User | Count |
---|---|
108 | |
56 | |
29 | |
21 | |
17 |