Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

If Function not evaluating the expression correctly in Matrix /Table

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.
 

 

Captured from Matrix

 

Captured from Table

 

 

If statements
Matrix Visual
Table

2 Replies

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    4 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.