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

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.

Follow this topic

Miguel Ramirez

Last answered:

13 Apr 2020

Posted on:

25 Mar 2020

count-per-row in PowerBi

1 answers ( 0 marked as helpful)

Dimitar Shutev

Instructor

Posted on:

13 Apr 2020

count-per-row in PowerBi

Submit an answer