Forum Discussion

Icon for Helper IV rank

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

Icon for Super User rank

Super User

2 years ago

Replace VALUES with MAX

anusha_2023
Helper IV
2 years ago
Thank you very much for your reply. Now I got only one city instead CostCenter has many customer countries how an I get all coutries when filtered from CostCenter and get Customer Countries to give as input to the Location in the filled map.
Measure Customer Country = CALCULATE(
MAX ( Customer[Country] ),USERELATIONSHIP
(Person[Id],Customer[Id]))
Right now even though I tried to give this as input the filled map Location it is not acceptable by the visual.
- lbendlin
  Super User
  2 years ago
  Switch from USERELATIONSHIP to TREATAS
  - anusha_2023
    Helper 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

Related content