Combine two datasets for making one measure for piechart

[Anonymous]

Hi,

I have the following data model:

I need a piechart with the sum of the uptime duration and the sum of the downtime duration per machine ID, where the downtime duration should also present the downtime description as a legend. Is there anybody who has an idea how to fix this in one piechart? Maybe a measure to combine these data?

[Anonymous]

@Anonymous 

It is difficult to provide a solution without sample data.

Quick solution is to use Both cross filter direction between Machine ID and Machine data downtime tables and keep "Apply security filters on both sides".

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

[kranthi82]

Hi @Anonymous ,

Probably silly suggestion but try merging queries if possible?

[Anonymous]

Can you help how to do that?

[kranthi82]

@Anonymous 

Try this: https://www.youtube.com/watch?v=hVWSxX-uF-0, hope it helps.

[Anonymous]

Hi,

I am working in direct query mode and merging tables is taking too long (> 0.5 hour and still not ready). Also filter on tables going both directions does not result in a solution, but I think I need some advice how to continue after setting the filters going both ways. Or maybe another solution possible? Thanks in advance for your help!