Forum Discussion
Second relationship - based on condition
Ah, got it!
It was as simple as filtering the visual with the Country data by the Machine ID (5 in this example).
v-huizhn-msft Thank you for your willingness to help with this basic question :)
But i couldn't rest so i kept poking this problem.Marking the thread as solved then.
Hi Angelia,
I suppose i'll be happy if both Germany and Italy are accossiated with the ID and Date.
And this is the case if i make a relationship between the Date.
However, it's also counting the Cappucinos for ID 10 and 12 that were also on 01-Jun-17 and this is what i don't want to happen. The relationship should only be valid if both the Date and the ID are the same. If i add ID 5 on every row on Dataset 2 (next to the Country data), will there be a way to do it from that?
Edit: This is what the current relationship looks like:
Regards,
Stefan
Ah, got it!
It was as simple as filtering the visual with the Country data by the Machine ID (5 in this example).
v-huizhn-msft Thank you for your willingness to help with this basic question :)
But i couldn't rest so i kept poking this problem.
Marking the thread as solved then.