Forum Discussion
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 do...
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!
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!
Chainfire74 great! You see, it was easy after all 🙂 when you have a proper model, in this case, you added a dim dates, everything including DAX is much simpler 😃