Forum Discussion
AllanBerces
4 months agoPost Prodigy
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...
- 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])))))
krishnakanth240
4 months agoSuper User
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])))))
- AllanBerces4 months agoPost Prodigy
Hi krishnakanth240 thank you very much work as i need
- krishnakanth2404 months agoSuper User
You are welcome AllanBerces !