Hello, I am a new user of Power BI Deskop. I face a relatively simple problem but I can't find an obvious solution...
I have a data set (see example below) with which I want to calculate the median number of entrance per day of the week.
When I make my graphs, the median is not correct because it calculates the values only between 1 and 0.
What is the best solution? Should I create different calculated tables with aggregated value by day of the week? should I make a measure with a DAX formula?
I have tried to use the "summarize" function without success. I also tried to creat a calulated table with the "group by" function but I am afraid that it will not be efficient when I have very large data sets. Thanks a lot for your help!