topic Re: Measure Running Count Total of Field in table 1, Slicer that uses date field in table 2 in DAX Commands and Tips

Measure Running Count Total of Field in table 1, Slicer that uses date field in table 2

Anonymous — Thu, 29 Dec 2022 23:16:11 GMT

I have table 1 that has a 'columnToCount' field that I'd like a running total to be put in a bar graph that has an x-axis from table 2 which has a date column that is used in a slicer and has a 1:* relationship between the 2 date columns.

I've tried the quick measure and many other solutions that use only 1 table that do work with 1 table, but because of the x-axis being from the second table my measure ignores what is filtered. Thanks so much for your time.

Sample data below:

Table 1

columnToCount	dateTable1
1	1/15/2022
2	4/15/2022
3	7/15/2022
4	12/15/2022

Re: Measure Running Count Total of Field in table 1, Slicer that uses date field in table 2

amitchandak — Fri, 30 Dec 2022 03:29:26 GMT

Anonymous , Can you share sample data from both tablesand sample output in table format? Or a sample pbix after removing sensitive data.

But new Window function can help

Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc

Running Total/ Cumulative: https://www.youtube.com/watch?v=h2wsO332LUo&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=41

Re: Measure Running Count Total of Field in table 1, Slicer that uses date field in table 2

v-zhangti — Fri, 30 Dec 2022 06:05:09 GMT

Hi, Anonymous

Measure = CALCULATE(SUM(Table1[Count]),FILTER(ALL(Table2),[Date]<=SELECTEDVALUE(Table1[Date])))

Is this the result you expect? If not, let us know what you expect the output to be.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.