Forum Discussion

Annihilo's avatar
Annihilo
Regular Visitor
4 years ago
Solved

cross-visual filter issues

Dear Community, I'm having an issue with visual filtering affecting a measure in an unexpected way. Background: There is a group of agents who do various types of services. I want to show the aver...
Need Help
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    Hi  Annihilo, 

     

    You need create a new table via code.

    Table = VALUES(Data[Name])
     
    And replace the [Name] from 'Data' with 'Table'[Name] in first table visual.
    Then change Avg_ALL code as the following.
    Avg_ALL =
    IF( [AverageDuration] = BLANK(), BLANK(),
    CALCULATE( [AverageDuration], ALL( 'Table'[Name] ) ) )

    Result: 

     

     

    Your pbix file in the end.

     

    Best Regards

    Community Support Team _ chenwu zhu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Annihilo's avatar
Annihilo
Regular Visitor
4 years ago

I use 'highlight' for the bar chart interaction. The 'average all' measure shows 123.61 minutes for the whole group. This is what I'd like to see retained if I switch the interaction to 'filter'.

But there it becomes 123.28. I don't understand the reason.

Link for the source pbix file:
Source 

v-chenwuz-msft's avatar
v-chenwuz-msft
Community Support
4 years ago

Hi  Annihilo, 

 

You need create a new table via code.

Table = VALUES(Data[Name])
 
And replace the [Name] from 'Data' with 'Table'[Name] in first table visual.
Then change Avg_ALL code as the following.
Avg_ALL =
IF( [AverageDuration] = BLANK(), BLANK(),
CALCULATE( [AverageDuration], ALL( 'Table'[Name] ) ) )

Result: 

 

 

Your pbix file in the end.

 

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.