Forum Discussion
Solved
Not able to cross filter data between Dimension and FACT table
Hello Eveyone I have one dimension table Account and Fact Table Amount We are using snowflake and we have applied RLS on snowflake side on FACT table Suppose I have access to 2 account, I can ...
Hi Pawanw511 , Thank you for reaching out to the Microsoft Community Forum.
Please try below:
TotalAmount =
CALCULATE(
SUM(fact_amount[amnt]),
ALL(fact_amount)
)
If this helped solve the issue, please consider marking it “Accept as Solution” so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.
v-hashadapu
Community Support
Community SupportHi Pawanw511 , Hope your issue is solved. If it is, please consider marking the answer 'Accept as solution', so others with similar issues may find it easily. If it isn't, please share the details.
Thank you.