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])

art12345's avatar
art12345
Frequent Visitor
2 years ago

This works! Many thanks. 

 

(Small edit needed at the end I think "... Data[Region] = Region"