Forum Discussion
Relationship Help
Hi Anonymous ,
The many-to-many relationship causes you to have the same value.
Maybe you need to create a landscape count column in each table.
In Landscape Value Bridge table, we create a column.
Landscape Column = CALCULATE(SUM('Results_LSC2 02 07 2020'[Landscape Count]), FILTER('Results_LSC2 02 07 2020', 'Results_LSC2 02 07 2020'[Standardised Attribute Name]='Landscape Value Bridge'[Standardised Attribute Name] && 'Results_LSC2 02 07 2020'[prefix]='Landscape Value Bridge'[prefix]&& 'Results_LSC2 02 07 2020'[Stand Value 1]='Landscape Value Bridge'[Stand Value 1]&& 'Results_LSC2 02 07 2020'[Stand Value 2]='Landscape Value Bridge'[Stand Value 2]))In Standardised Attribute Name Lookup w Value table we create a column too.
Landscapge column = CALCULATE(SUM('Results_LSC2 02 07 2020'[Landscape Count]), FILTER('Results_LSC2 02 07 2020', 'Results_LSC2 02 07 2020'[Standardised Attribute Name]='Standardised Attribute Name Lookup w Value'[Standardised Attribute Name] && 'Results_LSC2 02 07 2020'[Stand Value 1]='Standardised Attribute Name Lookup w Value'[Stand Value 1]&& 'Results_LSC2 02 07 2020'[Stand Value 2]='Standardised Attribute Name Lookup w Value'[Stand Value 2]))The result like this,
If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?
BTW, pbix as attached.
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
The many-to-many relationship causes you to have the same value.
Maybe you need to create a landscape count column in each table.
In Landscape Value Bridge table, we create a column.
Landscape Column =
CALCULATE(SUM('Results_LSC2 02 07 2020'[Landscape Count]),
FILTER('Results_LSC2 02 07 2020',
'Results_LSC2 02 07 2020'[Standardised Attribute Name]='Landscape Value Bridge'[Standardised Attribute Name] &&
'Results_LSC2 02 07 2020'[prefix]='Landscape Value Bridge'[prefix]&&
'Results_LSC2 02 07 2020'[Stand Value 1]='Landscape Value Bridge'[Stand Value 1]&&
'Results_LSC2 02 07 2020'[Stand Value 2]='Landscape Value Bridge'[Stand Value 2]))
In Standardised Attribute Name Lookup w Value table we create a column too.
Landscapge column =
CALCULATE(SUM('Results_LSC2 02 07 2020'[Landscape Count]),
FILTER('Results_LSC2 02 07 2020',
'Results_LSC2 02 07 2020'[Standardised Attribute Name]='Standardised Attribute Name Lookup w Value'[Standardised Attribute Name] &&
'Results_LSC2 02 07 2020'[Stand Value 1]='Standardised Attribute Name Lookup w Value'[Stand Value 1]&&
'Results_LSC2 02 07 2020'[Stand Value 2]='Standardised Attribute Name Lookup w Value'[Stand Value 2]))
The result like this,
If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?
BTW, pbix as attached.
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-zhenbw-msft,
Perfect, thank you! I actually removed the bridge tables entirely and just created "Count columns" from each source in the "Standardised Attribute Name Lookup w Value" table in the middle of my star and it all works perfectly. Much tidier! I'll leave the updated measures at the bottom of this post for anyone who needs them.
Thanks again v-zhenbw-msft!
Kind regards,
Jordan
Kingfisher Count Column =