Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
How can I calculate how many numbers are in the table
Clients are in rows
I am trying to get a table like
10 - 250
9 - 114
8 - 80...
Solved! Go to Solution.
Hi @Anonymous
You can use the countx() function
e.g:Measure 2 = COUNTAX(FILTER(ALLSELECTED('Table (2)'),[Num]=SELECTEDVALUE('Table (2)'[Num])),[Num])
For details, please refer to the following links:
COUNTX function (DAX) - DAX | Microsoft Learn
If the above does not meet your needs, can you provide some sample data?
Best Regards,
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
You can use the countx() function
e.g:Measure 2 = COUNTAX(FILTER(ALLSELECTED('Table (2)'),[Num]=SELECTEDVALUE('Table (2)'[Num])),[Num])
For details, please refer to the following links:
COUNTX function (DAX) - DAX | Microsoft Learn
If the above does not meet your needs, can you provide some sample data?
Best Regards,
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous can you share a little bit more information, including desired output?
User | Count |
---|---|
79 | |
74 | |
44 | |
32 | |
28 |
User | Count |
---|---|
100 | |
93 | |
52 | |
50 | |
48 |