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
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
Solved! Go to Solution.
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
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.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.
@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
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.