Forum Discussion

Chainfire74's avatar
Chainfire74
Helper I
4 years ago
Solved

Two different data sources in one visual

Hi, I've created a line chart which will have starters and leavers, there are two different tables (one for each).

 

Both tables have the relevant dates, however when I want to break the results down by quarters it is only updating one of the table numbers while the other numbers stay the same throughout the whole quarters. Could anyone help with this please?

 

 

Need Help
  • Chainfire74's avatar
    Chainfire74
    4 years ago

    Unfortunately, where I work won't allow it. Thank you so much for offering to help though.

     

    I have found a solution:

     

    Starters = CALCULATE(distinctCOUNT(Starters4[Employee Number]))
     
    This worked and I've managed to get the table looking how I wanted it.
     
    Thanks again!