How can I calculate how many numbers are in the table

[Anonymous]

Hi,

How can I calculate how many numbers are  in the table

Clients are in rows

ActiveSale_mnth = CALCULATE(DISTINCTCOUNT('Data'[Date]),'Data'[Sale] > 0)

I am trying to get a table like

10 - 250

9 - 114

8 - 80...

[Anonymous · Accepted 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.}

[AbbasG]

@Anonymous  can you share a little bit more information, including desired output?