Miguel Ramirez
Last answered:

13 Apr 2020

 Posted on:

25 Mar 2020
0

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
1 answers ( 0 marked as helpful)
Dimitar Shutev
Instructor
Posted on:

13 Apr 2020
0
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.

Submit an answer