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 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!

Need Help
Tips and Tricks

3 Replies

  • 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.

     

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

      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.