Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have a scenario to show matching and non-matching rows in the Pivot table.
Currently showing in two pivots as used Measure to filter.
Sample data are shown in the below image.
Thank You.
HI @tulasi_pbi1988,
I'd like to suggest you add a calculated column to 'table 1' to show the tag based on 'table 2' records.
Column =
IF (
COUNTROWS (
FILTER (
Table2,
[Country] = EARLIER ( Table1[Country] )
&& [Prid] = EARLIER ( Table1[PRID] )
)
) > 0,
"Matched",
"No Matched"
)
EARLIER vs EARLIEST in DAX - Excelerator BI
Regards,
Xiaoxin Sheng
I see your thread, and going back to your questions:
If the relationship is Many to Many means? Make no difference but it is better to have 1 to many relationship
I have the same scenario to do, but I have Many to Many relationship. Where is the issue??
Do you have anything like this, please? Did you download my Pbix sample from the other Thread?
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Please see this link:
https://radacad.com/combining-tables-in-power-bi-union-except-and-intersect-in-dax
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |