Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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.
and then using output of AV_A to compare with measure AB_B with the help of measure Test
Captured from Matrix
Captured from Table
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.
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
10 | |
10 | |
9 | |
9 |
User | Count |
---|---|
20 | |
13 | |
12 | |
11 | |
8 |