Forum Discussion
Solved
TOTALYTD Total in Table
DATE COUNTS COUNTS TYTD 2021-03 30 89 2021-02 28 59 2021-01 31 31 2020-12 26 323 2020-11 24 297 2020-10 42 273 2020-09 31 231 2020-08 22 200 2020-07 3...
Hi, NickTT
Please try the below measure.
The sample pbix file's link is down below.
Counts TYTD FIX =SUMX( VALUES('Date'[Year]), TOTALYTD([Counts Total], 'Date'[Date]))Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
That works correctly in a Matrix but what about Table? In a Table it's returning the same row values as COUNTS.