Forum Discussion

david_blabla's avatar
david_blabla
Frequent Visitor
6 years ago
Solved

Count rows by date on unconnected sources

Hi there!   I have two unconnected sources in my BI file: Activities Finished on 1 1.1.2020 2 1.1.2020 3 2.1.2020 4 2.1.2020 5 3.1.2020   And a calendar including all ...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    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

v-kelly-msft's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
6 years ago

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

david_blabla's avatar
david_blabla
Frequent Visitor
6 years ago

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?