Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Farhan_Raza
Frequent Visitor

Count Rows Within Table Chart

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

aaa.png

I want to get 8 as final answer

1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

Hi @Farhan_Raza 
Please try

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

View solution in original post

3 REPLIES 3
tamerj1
Super User
Super User

Hi @Farhan_Raza 
Please try

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

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 ?

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors