Forum Discussion

art12345's avatar
art12345
Frequent Visitor
2 years ago
Solved

Remove filter only on rows to sum but keep context filter

Hi all,    I hope you can help me with the following.    I have the following data set.    Loan Region Borrower Amount A EU Company A 100 B EU Company B 200 C US Company ...
Need Help
  • JamesFR06's avatar
    JamesFR06
    2 years ago

    HI

    Var Region=selectedvalue(Data[Region])

    return

    Calculate( Sum(Data[Amount]), Removefilter(), Data[Region] = Data[Region])

JamesFR06's avatar
JamesFR06
Icon for Resolver IV rankResolver IV
2 years ago

HI

Var Region=selectedvalue(Data[Region])

return

Calculate( Sum(Data[Amount]), Removefilter(), Data[Region] = Data[Region])