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,
I cannot seem to figure out how to create a measure to count how many times people in Table 1 appear as a Nominee in Table 2 with the Category status as "Now" more than once.
Table 1
Table 2
Thank you,
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
Hi,
Show the result you are expecting and share the link from where i can download your PBI file.
I would expect to see a count of 2 as from Table 1 only 'Jessica Jay' and 'Alexis Reyes' appear in table 2 as Nominee Name with Category "Now" more than once.
In the PBI file, I created a relationship between the two tables and created a table to show the names from table 1 who appear in table 2
Hi,
You may download my PBI file from here.
Hope this helps.
This is great. Appreciate the quick response!
You are welcome.
Create a relationship between your tables and create a measure that counts the nominee on the table 2.
Count Nominee = CALCULATE( COUNT( YourTableName[Nominee Name]) , YourTableName[Category] = "Now" )
Use your employee name of table1 and the measure you created
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 |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |