Forum Discussion

HB13's avatar
HB13
Icon for Helper I rankHelper I
4 years ago

Create a list filter with an inactive relationship

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 tabl...
Need Help
Tips and Tricks
v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
4 years ago

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.