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 Turnipface,
For example, the Machine ID is 5. We For Date 01-Jun-17, there are two products(Cappuccine, Espresso), and there are two countries(Germany and Italy). How to create it, what's results do you want to get? Could you please share more details for further analysis?
Best Regards,
Angelia
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
Hi Turnipface,
In your Bridge table, please create a calculated column to get the country using the formula.Country = CONCATENATEX(Country Date,Country Date[Country] & ",")
Then in your Machine Data, create a calculated column using the formula.Country=RELATED(Bridge[Country])
Best Regards,
AngeliaAh, 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.