topic If Function not evaluating the expression correctly in Matrix /Table in DAX Commands and Tips

If Function not evaluating the expression correctly in Matrix /Table

Anonymous — Thu, 09 Jun 2022 08:58:59 GMT

I am trying to compare the values of a table(B) with a lookup Value( From Table A)

I am using FileDate to pick the value AV from Table A using measure,AV_A.

AV_A =

var dt = SELECTEDVALUE('B'[FileDate])

var av_m = CALCULATE(sum('A'[AV]), FILTER(('A'), 'A'[FileDate] = dt))

return av_m

and then using output of AV_A to compare with measure AB_B with the help of measure Test

AV_B = (SUM('B'[AV]))

Test = IF([AV_A] = [AV_B],TRUE(),FALSE())

Looks pretty simple and easy. But I am perplexed by the result it produced in Matrix or table visualization. I am attached the screenshot by Highlighting the anamoly.

I also dont want to show the values at subrow level ('distinct') and Total but want to show True/False for the Top row level ('Field') in matrix.

Any insight by the community members will be highly appreciated.

Re: If Function not evaluating the expression correctly in Matrix /Table

v-xiaotang — Mon, 13 Jun 2022 07:18:41 GMT

Hi Anonymous

Thanks for reaching out to us.

Could you please provide some sample data in table A & B? And the expected outcome according to it? Thanks.

>>I also dont want to show the values at subrow level ('distinct') and Total but want to show True/False for the Top row level ('Field') in matrix.

Is the outcome below you want to get?

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

Re: If Function not evaluating the expression correctly in Matrix /Table

Anonymous — Mon, 13 Jun 2022 07:56:12 GMT

Hello Team_Tang,

Yes I want to get the outcome as you mentioned in screenshot and no Grand Total in matrix.

I am includng the screenshot of all values of Table A and some values of table B.