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.
Hai All Need your help on this
The requirement is Want to find the headcount of the Latest Division, I Had already found the Latest division. But the requirement is not completed for example
I Have Column Like
Latest Divison |
ABCDEFGHI |
I want to take count of these corresponding latest division values.
Please help me
Solved! Go to Solution.
Hi @Anonymous ,
Not very sure about what the table looks like in your model. Please try the following formula.
Useremail Count =
CALCULATE (
COUNT ( [email column] ),
FILTER ( 'table name', [division column] IN [Latest Division] )
)
If it doesn’t work, could you please provide some sample data in your tables and tell me the relationships between them so I can help you find a solution?
Best Regards,
Community Support Team _ Caiyun
Hi @Anonymous ,
Not very sure about what the table looks like in your model. Please try the following formula.
Useremail Count =
CALCULATE (
COUNT ( [email column] ),
FILTER ( 'table name', [division column] IN [Latest Division] )
)
If it doesn’t work, could you please provide some sample data in your tables and tell me the relationships between them so I can help you find a solution?
Best Regards,
Community Support Team _ Caiyun
I Have a column Called Latest Divison,
Expecting output is
Latest Divison | Useremail COunt | ||
ABCDEF@GMAIL.COM | 15 | ||
EFGHI@GMail.com | 20 | ||
HIJKL@GMAIL.COM | 25 |
@Anonymous ok, the expected output is clear, but can you paste some data on which you want to calculate this result?
Thx,
BF
@Anonymous Hi!
Can you paste some sample data?
Thx,
BF
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |