Forum Discussion
ChrisR22
Helper III
Helper IIIMeasure not abiding by filters
Hello, I have a measure that compares the values of two columns from different tables, and returns whether the values match or not. PCAP Amount Match = var _Table1 = SUM(Table1[Amount]) var ...
Gotcha, I missed that part!
I think the KEEPFILTERS function should do the trick. Something like:PCAP Amount Match =VAR _Table1 = CALCULATE(SUM(Table1[Amount]), KEEPFILTERS(Table1[FieldA]))
VAR _Table2 = CALCULATE(SUM(Table2[PCAP Amount]), KEEPFILTERS(Table2[FieldA]))returnIF(ROUND(_Table1, 2) = ROUND(_Table2,2), "Match", "Break")
ChrisR22Helper III
Helper IIIThat worked! Thank you so much