Forum Discussion
MasterSonic
Helper IV
Helper IVCount rows in date table where date is ...
Hi guys trying to count rows in date column. Simply I would like to get result as count rows where date is "20/07/2020" and muliply by 50. I did try countrows but it gives error about not ...
ok please try :
Measure = CALCULATE(COUNTX(Table1,Table1[Column]),FILTER(Table1,Table1[Date] = DATE(2022,07,20))) * 50
ok please try :
Measure = CALCULATE(COUNTX(Table1,Table1[Column]),FILTER(Table1,Table1[Date] = DATE(2022,07,20))) * 50
MasterSonicHelper IV
Helper IVThank You,
verision with
COUNTX
works