Forum Discussion

dwauer's avatar
dwauer
Frequent Visitor
2 years ago

Count HeaderRow in Matrix Table

Hello again,

 

how can I count the header row in a matrix table?

 

I would only show 5 instead of 15 rows as counting number.

With my measure it won't work.

 

Thanks

 

Need Help

2 Replies

  • Daoud_H's avatar
    Daoud_H
    Helper I
    2 years ago

    Hi dwauer,

     

    Can you show your dax measure please ? 

    It seem that you have put 2 columns in this matrix.

    • dwauer's avatar
      dwauer
      Frequent Visitor
      2 years ago

      Here is my Measure:

       

      MontageSollHeute = 
CALCULATE(
        COUNTROWS(
            'AG - Rückmeldungen (Handy App)'),
            FILTER(
                'AG - Rückmeldungen (Handy App)',[Arbeitsgangnr.] = 70 &&
                [Arbeitsplannr.] = "GLAS" &&
                [Glasstandort] = "GLAVOR1"
        )   )+0