Value from measure not filtering other visuals correctly

[Anonymous]

This has been puzzling me for a very long time! I will try my best to explain:

I have a fact table and a dimenstion table (plus many other tables that aren't included in these calcs)

I have created 2 measures

• Measure 1 counts all the rows in the fact table
• 
• it is used to count number of rows per group (group is from a dimension table)
• 
• Measure 2 counts all the rows in the fact table (using measure 1) but has a filter on one of the columns
• 
• it is used to count number of rows per group (group is from a dimension table) that match the criteria "Yes"
• 

It all looks good, but when I click on the '1' in the second visual, it does not filter the first visual correctly, and I can't figure out why the measure is completely ignoring the "Yes" filter

There is a relationship between both tables (one to many) and I have tried changing this to both directions as well.

The only way I can get this to work is by adding the criteria column from the fact table, as a filter on the visual, and selecting "Yes"

Then when I click on the '1' it filters the top visual correctly 

I can't use this method because I have another column (with a "Yes" "No" criteria) that I need to show in the same visual, and having a visual filter on one column affects the values on the whole visual.

Behind the scenes, it seems to be reading the data like this (where it gets the 128 number from)

Any help would be extremely appreciated

[Anonymous · Accepted solution]

This seems to explain why my measure filters don't work in a Drill Through scenario:
Solved: drillthrough is not working with measure filters - Microsoft Power BI Community

[Anonymous]

thank you @amitchandak, how would you then go about solving this? Is my measure calculated incorrectly? Do I need a new summarised table? I'm unsure how to proceeed

[V-lianl-msft]

Hi @Anonymous ,

The interaction between visuals cannot pass the filter in the measure.The interaction between the two visuals is due to the fields(C,H,R,S...) in the static column, not measure.The measure calculation is correct, but you have some misunderstandings about the measure attribute. Measure is calculated based on the current row context.

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

[Anonymous]

Thank you @V-lianl-msft. If I am understanding correctly, my measure is not able to filter my dimension field? I should also note that the field in my dimension table that is the axis for both visuals contains duplicate values. The unique distinct values in this table are is list of building codes, in the same dimension table I have another field that groups these building codes into four categories (these are the C H R S). Maybe this is also causing issues? 

Apologies for my confusion I am still fairly new to PBI.

Is there a way at all to get the results I'm trying to achieve? Some steps to follow would be very helpful. 

[amitchandak]

@Anonymous , Only the not summarized column used in visual will only pass as a filter. The filter used in the measure will not pass. hence "Yes" used as a filter in the measure is not getting passed