Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 supporting date and text values
Solved! Go to Solution.
ok please try :
Measure = CALCULATE(COUNTX(Table1,Table1[Column]),FILTER(Table1,Table1[Date] = DATE(2022,07,20))) * 50
thats weird can you try :
Calcualte(Count(table[date]),filter(table,table[date] = DATE(2022,07,20))) * 50
if this works please consider acceptig it as solution and kudos
HI there,
this bit works fine
Calcualte(Count(table[date]),filter(table,table[date] = DATE(2022,07,20))
but after adding
* 50
I got this error
A function 'FILTER' has been used in a True/False expression that is used as a table filter expression. This is not allowed.
i think you missed a bracket when closing the calculate please make sure
Calcualte(Count(table[date]),filter(table,table[date] = DATE(2022,07,20))
this should be
Calcualte(Count(table[date]),filter(table,table[date] = DATE(2022,07,20)))
ok please try :
Measure = CALCULATE(COUNTX(Table1,Table1[Column]),FILTER(Table1,Table1[Date] = DATE(2022,07,20))) * 50
Thank You,
verision with
COUNTX
works
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
10 | |
6 |