Forum Discussion

Farhan_Raza's avatar
Farhan_Raza
Frequent Visitor
4 years ago
Solved

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 anot...
chart
Table
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi Farhan_Raza 
    Please try

    Count =
COUNTROWS (
    FILTER (
        SUMMARIZE (
            TableB,
            Calender[Date],
            TableA[PO#],
            "@Margin", SUM ( TableB[Margin] )
        ),
        [@Margin] >= 1000
    )
)
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Farhan_Raza 
Please try

Count =
COUNTROWS (
    FILTER (
        SUMMARIZE (
            TableB,
            Calender[Date],
            TableA[PO#],
            "@Margin", SUM ( TableB[Margin] )
        ),
        [@Margin] >= 1000
    )
)
  • Farhan_Raza's avatar
    Farhan_Raza
    Frequent Visitor
    4 years ago

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

  • Farhan_Raza's avatar
    Farhan_Raza
    Frequent Visitor
    4 years ago

    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 ?