Power BI Status Count

Question

So, there's this log table that shows me the order log per day. This table has one measure and one column which are:

Column Date:

AllDates = CALENDAR(MIN('LOG'[DTH_INCLUI_LOG]);MAX('LOG'[DTH_INCLUI_LOG]))

Measure LogStatus:

VAR CurrentDate = SELECTEDVALUE(AllDates[Date])
VAR MaxDate = CALCULATE(MAX('LOG'[DTH_INCLUI_LOG]);'LOG'[DTH_INCLUI_LOG] <= CurrentDate+1)
RETURN CALCULATE(MAX('LOG'[VLR_NOVO]); 'LOG'[DTH_INCLUI_LOG] = MaxDate)

Now I need to create a new table that counts the amount of each status per day. Example: On day one got 45 status A, 75 status P, 35 status Q (...)

How do I do it?

Answer 1

Try COUNT, COUNTX, or COUNTROWS .