Forum Discussion

lfrigione's avatar
lfrigione
Icon for Helper II rankHelper II
4 years ago
Solved

PowerBI relations

Hi, I have three tables: Facility(FacilityId, FacilityName, ...) AgeRange(AgeRangeId, minAge, maxAge, FacilityId, ...) ClientPeriod(ClientId, From, To, AgerangeId, FacilityId, ...) I have two ac...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    HI lfrigione,

    It seems like userelationship and RLS conflicts with the real and virtual relationship mappings.
    Have you try to removing the virtual relationship and manually using the DAX expression to apply a filter in your calculations?

     

    Test =
VAR inativeFilter =
    VALUES ( AgeRange[AgeRangeId] )
RETURN
    CALCULATE (
        COUNTROWS ( ClientPeriod ),
        FILTER ( ALLSELECTED ( ClientPeriod ), [AgeRangeId] IN inativeFilter )
    )

     

    Regards,

    Xiaoxin Sheng

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

lfrigione , Facility should not join with AgeRange, it should only join with ClientPeriod,

 

if need have one inactive join when needed

lfrigione's avatar
lfrigione
Icon for Helper II rankHelper II
4 years ago

Hi amitchandak ,

thank you for replying.

I need this relation because evey Facility has it's own age ranges.

When one account log in I would like to use RLS to filter this content.