Create a list filter with an inactive relationship

[HB13]

Hi PBI gang

I have two fact tables that have invalid relationships with a dim table

In my dim table I have a column that consists of RiskTypes. I want to group certain values from my fact tables by RiskType but because the relationships are inactive it does not reflect value per risktype correctly. 

I do not want to change the current data model as it will affect a lot of my other visuals, so I was wondering how to create a RiskType "measure" (with the USERELATIONSHIP function) can be used to group the fact table values.

Is this possible or is there another way around this?

Many thanks!

[v-yalanwu-msft]

Hi, @HB13 ;

You could create a measure like below:

dax =
CALCULATE (
    SUM ( 'A'[Value] ),
    FILTER ( ALL ( 'B' ), [RiskTypes] = MAX ( 'A'[RiskTypes] ) )
)

Or use USERELATIONSHIP .

If not ok , can you share a simple file and the result you want to output?

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[NickolajJessen]

When asking a question about your data model. Include picture of said data model and either a screen shot of the manage relationship tab in PBI or explaination of connections.

For other good tips on posting, make sure to visit the pinned thread:
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/2564882#M9069...

[HB13]

Hi @NickolajJessen 
My question was not with regards to a data model, I am asking how to group values by a category using the inactive relationship between my tables. 
Thanks though.