cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
marijane12 Regular Visitor
Regular Visitor

Average number of persons by days of the week and code

I have a measure Nº pessoas =distinctcount(horarios[idpessoa]) that counts the number of persons. What I want is a table that shows the average of number of persons by days of the week and code. In the picture Domingo =sunday, Segunda-Feira Terça-Feira=Tuesday and the values shows the number of persons. (not what I want) I try 

AVERAGEX(KEEPFILTERS(VALUES('Date'[Dia Semana])); CALCULATE([NºPessoas])) but it doesn't work


horarios2.PNG

 

The average for domingo and 0000089415 should be 0,25 in the picture above-As you see in the picture below there are only one person for 4 domingos(sundays). Btw do you know why the total for 0000083646 and domingo is 3 (picture below)? shouldn't be the sum of persons for all days of domingo? Thank you in advance.

 

horario.PNG

1 REPLY 1
Super User
Super User

Re: Average number of persons by days of the week and code

Hi @marijane12 ,

 

Can you share a sample of the data and the model you have?

 

Please see this post regarding How to Get Your Question Answered Quickly:

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490 (courtesy of @Greg_Deckler).

 

Regards,

MFelix



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 311 members 3,044 guests
Please welcome our newest community members: