Forum Discussion
Get table total as column while having filter condition from related table slicer (ALLSELECTED)
hello dogba
i might be misunderstood but i am using your DAX but get different result with EMEA.
Have you created a relationship between fact and dim table?
it is one-to-one in my screenshot, but in your original table it most likely one-to-many from dim to fact table.
Hope this will help.
Thank you.
Hi dogba
Thank you for reaching out microsoft fabric community forum.May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
hello dogba
i might be misunderstood but i am using your DAX but get different result with EMEA.
Have you created a relationship between fact and dim table?
it is one-to-one in my screenshot, but in your original table it most likely one-to-many from dim to fact table.
Hope this will help.
Thank you.
Thank you for your response - can you see my reply above?
I think my question was unclear - the Policy field must come from FACT table in the final table visual as the original relationship is on a different category field.
I will update my question but hopefully it is clearer this time - is this possible to achieve?
hello dogba
if you want to filter out a value like you have shown in expected behaviour, your need a value in table visual that has a relationship from your dim tabl.
from your updated question, seems there is no relationship between your sample data (the relationship goes to another column which is not shown in sample data).
please share a sample data that represent your original data.
there might be a way around to achive your requirement (consume Policy from fact tbl).
Thank you.