Forum Discussion

AllanBerces's avatar
AllanBerces
Icon for Post Prodigy rankPost Prodigy
4 months ago
Solved

Wrong Total

Hi can anyone help me correct the column total on my table, my measure is 

 

Count S-01 =
COUNTROWS(
FILTER(
'Table',
MONTH('Table'[01]) = MONTH(MIN('Table'[01]))
)
)
and 
Count S-02 =
COUNTROWS(
FILTER(
'Table',
MONTH('Table'[02]) = MONTH(MIN('Table'[02]))
)
)
they are connected to my index month table

Thnak you

 
Need Help
  • krishnakanth240's avatar
    krishnakanth240
    4 months ago

    Hi AllanBerces 

    Can you try this 

    Count S-01 =
    SUMX(
    VALUES('Month Table'[Month]),
    CALCULATE(COUNTROWS(FILTER('Table', MONTH('Table'[01]) = SELECTEDVALUE('Month Table'[Month Index])))))