topic Re: Count Rows Within Table Chart in DAX Commands and Tips

Count Rows Within Table Chart

Farhan_Raza — Thu, 15 Sep 2022 05:15:54 GMT

Hello everyone,

Is there a way to count rows within the table chart ? I have a date column coming from calender table and another column (margin) from a Table (Table B) and the rest are from another table (Table A). I want to count rows where margin is >=1000.

Table relationship is :
Calender -> Table A -> Table B (single and one to many)

Please help

I want to get 8 as final answer

Re: Count Rows Within Table Chart

tamerj1 — Thu, 15 Sep 2022 09:21:23 GMT

Hi Farhan_Raza
Please try

Count = COUNTROWS ( FILTER ( SUMMARIZE ( TableB, Calender[Date], TableA[PO#], "@Margin", SUM ( TableB[Margin] ) ), [@Margin] >= 1000 ) )

Re: Count Rows Within Table Chart

Farhan_Raza — Thu, 15 Sep 2022 09:57:44 GMT

Thank you so much. I knew it had to do with summarize function but I couldn't remember the format

Re: Count Rows Within Table Chart

Farhan_Raza — Thu, 15 Sep 2022 10:53:51 GMT

A quick question, suppose the relationship is inactive between Table A & Table B, how do I incorporate within this formula ? Do I have to use USERELATIONSHIP function ?