Forum Discussion

anusha_2023's avatar
anusha_2023
Icon for Helper IV rankHelper IV
2 years ago

Filled Map with inactive relationship

I am trying to visualize country column data from the Customer dimension using the filled map     I have a slicer from CostCenter[Name] and need to reflect country data in the map. Due to th...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Switch from USERELATIONSHIP to TREATAS

anusha_2023's avatar
anusha_2023
Icon for Helper IV rankHelper IV
2 years ago

I tried to post pbix file but I could not able to find an option to attach here.To be more clear I have slicer from CostCenter on the Level field and I posted the data model and map again to be clear and I cannot change he relationships as I have other dimentions and facts which might effect.

Measure Customer Country =
CALCULATE(
    VALUES(Customer[Country]),
    REMOVEFILTERS(Person),
    KEEPFILTERS(Customer),
    USERELATIONSHIP( PersonView[ID],'MDCustomer'[Owner]
    )
)

I used above measure to rectify the issues but still getting the same error as below

 

Not sure how to rectify with treatas. Please help me further if any of you can suggest any further views