count-per-row in PowerBi
Hi,
Could you please help me with the following problem i've been facing in PowerBi
I want to sum how many tickets i received per day, but the COUNT and SUM always shows same data and that affects the StandardDeviation due i don't need to count Sundays and Saturdays
This is my code:
Table = ADDCOLUMNS(CALENDAR(MIN('General Tickets'[Request Date]), MAX('General Tickets'[Request Date])),
"SumOfTickets", CALCULATE(COUNTROWS('General Tickets'), FILTER('General Tickets', 'General Tickets'[Request Date] <> 6), FILTER('General Tickets', 'General Tickets'[Request Date] <> 7)))
This is the result:
Thank you
Thank you
1 answers ( 0 marked as helpful)
Hi Miguel,
The correct way to do it is to separate this measure out of the calculated table
CALCULATE(COUNTROWS(‘General Tickets’), FILTER(‘General Tickets’, ‘General Tickets'[Request Date] <> 6), FILTER(‘General Tickets’, ‘General Tickets'[Request Date] <> 7))
Then you can use this measure against your date data and this will return the desired result, then you can format the results inside a table visual.