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.
Hello,
Assuming I have two tables
Table1:
Name1
Name2
Name3
and Table2
Name1
Name2
Name1
Name2
Name4
Name5
Relationship one [Table1] many [Table2]
I would like to create a masure that will count, how many values from one side of the relationship, matches values from many side of the relationship (2) and another value how many does not (1)
Solved! Go to Solution.
hi @Pbiuserr
try to plot two card visuals with measures like:
count1 =
COUNTROWS(
INTERSECT(
ALL(Table1[Name]),
ALL(Table2[Name])
)
)
count2 =
COUNTROWS(
EXCEPT(
VALUES(Table2[Name]),
VALUES(Table1[Name])
)
)
it worked like:
hi @Pbiuserr
try to plot two card visuals with measures like:
count1 =
COUNTROWS(
INTERSECT(
ALL(Table1[Name]),
ALL(Table2[Name])
)
)
count2 =
COUNTROWS(
EXCEPT(
VALUES(Table2[Name]),
VALUES(Table1[Name])
)
)
it worked like:
Thank you! Can you advise what to do if second table has more columns than first one? Tried VALUES etc but does not work
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 |
---|---|
115 | |
100 | |
90 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |