Visuals do not filter correctly when using measures as columns

[mheagerty]

Hi,

I am having trouble with visuals and filtering when using measures as columns (between two 'table visuals')
The measures in table1 visual are correct, however when i try and click on a selectable field, it does not filter correctly in visual table2,

However, when  vice versa this works correctly - e.g. i click on a row in 'visual table 2', and it filters correctly in 'visual table 1'

DAX for measures are as follows:

<14 Days = COUNTROWS(FILTER('Table',[Average TTP (Days)] >= 8 && [Average TTP (Days)] <= 14))

[v-tangjie-msft]

Hi @mheagerty ,

Thanks Ritaf1983  for the quick reply. I have some other thoughts to add:
Based on your description, you want to filter out Not Compliant rows when clicking on a card visual object, which is not possible. You can manually add the filter on the visual object filter on the right side.
For your second question, this is also due to the design.

Best Regards,

Neeko Tang

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

[mheagerty]

I am unable to provide you with the pbix or dummy data at this stage, however please see an example below:

One of the visuals in my report counts all rows of a measure created for values 'compliant' and not compliant' in my table.

While the visual (count) works correctly, the table still shows rows with 'Compliant'. If possible, I would like to also filter those out when I 'click' on the visual for 'Not Compliant'.

I would also like the same to apply when I click on the individual counts from my top-right visual. This will count all rows that match criteria for 'Average TTP (Days)'. Each column in this visual is also a measure (-7days, -14,days, etc)

[Ritaf1983]

Hi @mheagerty 

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly