Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Shape Map Advanced Filtering with cards & slicer

Hi, I’m new to this forum and would appreciate your help. I’ve built a report with a shape map, a dropdown slicer and several cards. The slicer allows to select a year and pressing a state shows va...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Anonymous,

     

    I made one sample for your reference.

     

    We can create a measure as below to work on it.

     

    Measure = var _Catoosa = CALCULATE(SUM(Sheet1[Total]),FILTER(Sheet1,Sheet1[_State]= "Catoosa"))
return
IF(ISFILTERED(Sheet1[_State]),CALCULATE(SUM(Sheet1[Total])),_Catoosa)

     

     

     

     

     

    Regards,

    Frank

v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi Anonymous,

 

I made one sample for your reference.

 

We can create a measure as below to work on it.

 

Measure = var _Catoosa = CALCULATE(SUM(Sheet1[Total]),FILTER(Sheet1,Sheet1[_State]= "Catoosa"))
return
IF(ISFILTERED(Sheet1[_State]),CALCULATE(SUM(Sheet1[Total])),_Catoosa)

 

 

 

 

 

Regards,

Frank

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Worked fine, except need to format results . I tried severall combinations with Format function #,##0 but keep getting an error message. Any ideas?

     

    Thanks