Forum Discussion
Not able to cross filter data between Dimension and FACT table
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.
Super UserThose other measures should normally return blank for those outside RLS. It's just that, you added an ALLSELECTED measure in the viz so all rows are visible. Alternatively, you can filter your viz form the filter pane to show only those with amount.
danextian
Account are not fixed , it can be dyamically changed based on user role
there may be chance that for some account amount could be blank
If i filter it out , I will loose account for which blank row is there
- danextian
You might have misread my reply.
Alternatively, you can filter your viz form the filter pane to show only those with amount.
Amount <> blank.