The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

count-per-row in PowerBi

Back to all questions

count-per-row in PowerBi

Super Learner 6 months ago
Vote Up Vote Down
0
Votes
1
Answer

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 Answer

365 Team 6 months ago
Vote Up Vote Down
0
Votes

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.

You must to answer this question.

Not the answer you are looking for? Browse other questions tagged #.