Forum Discussion
Count rows by date on unconnected sources
Hi david_blabla ，
You only need to modify your dax expression as below:
Cumulative Finished = CALCULATE(COUNT(activities[actual_finished]);FILTER(ALLSELECTED(activities);activities[actual_finished] =selectedvalue('Calendar'[Date])))Then you can compare the values per day.
Best Regards,
Kelly
I tried connecting the two tables but it does not help me since I want to be able to comapre Planned vs. Finished vs. Confirmed per day.
I use the following measure to create a very similar chart which shows Planned vs. Finished vs. Confirmed cumulative in a line chart.
Cumulative Finished = CALCULATE(COUNT(activities[actual_finished]);FILTER(ALLSELECTED(activities);activities[actual_finished] <= MAX('Calendar'[Date])))
I think I basically need to create a similar measure that cumulates not from the beginning of the project until the date shown in the chart but per date shown in the chart separately.
Does that make sense?
Community SupportHi david_blabla ，
You only need to modify your dax expression as below:
Cumulative Finished = CALCULATE(COUNT(activities[actual_finished]);FILTER(ALLSELECTED(activities);activities[actual_finished] =selectedvalue('Calendar'[Date])))
Then you can compare the values per day.
Best Regards,
Kelly
Awesome, now I have a table that shows the same values for my "column in calendar workaround" as well as your dax statement.
For some reason tho the bar chart does show values for my "column in calendar workaround" but not anything if I include the dax statement.
Any idea why?