[DAX] COUNTROWS
May 19, 2021
COUNTROWS vs. Physical Table
Days In Month =
CALCULATE(
COUNTROWS(Dates),
ALL(Dates),
VALUES(Dates[Month&Year])
)
COUNTROWS vs. Virtual Table
Total Orders above 100 =
COUNTROWS(
FILTER(Sales, Sales[Revenue] > 100)
)
Days In Month =
CALCULATE(
COUNTROWS(Dates),
ALL(Dates),
VALUES(Dates[Month&Year])
)
Total Orders above 100 =
COUNTROWS(
FILTER(Sales, Sales[Revenue] > 100)
)