cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Frequent Visitor

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]))
TestIF([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

2 REPLIES 2
Frequent Visitor

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.

Community Support

Hi @mohitkr_01

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.

Announcements

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors