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.
Hi,
These images should clarify
Thank you for your response. Your solution works but in my table visual, I need the field Policy to come from FACT table (not DIM). Realise my example may have been a little too simple as my original relationship is not on the policy field but a different category. As such, this would not allow me to use Policy field from the region dimension table.
This is what I am getting on using Policy from FACT table (note how measure returns row total and not overall total)
Is there any way to achieve this?
You are welcome. That is not the right table to drag it from. That field should be dragged from the Dim table.