Forum Discussion

AllanBerces's avatar
AllanBerces
Post 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  Cou...
  • krishnakanth240's avatar
    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])))))