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
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