Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi! Do you have any tip to solve this issue?
I need to create a table like the one attached (Store vs. #Visits per Month) and add a column with the average of the months.
But when I do this, Power BI applies the Average for each column, each month. And I would like it to include only 01 more column in the report.
Hi @Anonymous , would you give us a little more detail?
You drop the column Noma da Loja on the matrix, and then what?
Thank you,
Nathaniel
Proud to be a Super User!
Hi @Nathaniel_C
Actually the problem are the columns. When I drop the "Average Visits" measure, it splits the columns of each month (June, July, August) into "Qty Visits" and "Avg Visits".
But I need to have a table where: each month only shows the column "Qty Visits"; Totals shows both "Qty Visits" and "Average Visit".
@Nathaniel_C wrote:Hi @Anonymous , would you give us a little more detail?
You drop the column Noma da Loja on the matrix, and then what?
Thank you,
Nathaniel
@Anonymous ,
So it sounds like the Average Visits measure is the problem. Would you be able to share that with us?
Nathaniel
Proud to be a Super User!
Hi @Anonymous ,
I worked on this, but didn't get anywhere. Then just now was thinking it might have something to do with the hierachy, tried to go around that but generating a column that gave Month Name, but still didn't get it.
Maybe @jdbuchanan71 has some insight?
Proud to be a Super User!
Even if you force the average measure to return a blank with something like this.
Avg Visits = IF ( ISINSCOPE( 'Table'[Month].[Mês] ), BLANK(), AVERAGE( 'Table'[Qtd Visitas] ) )
It will still show the blank column under every month.
PowerBI does not seem to like asymetric reporting (visits on the months but visits and average on the total). The best I have found to do is make the extra columns narrow enough that they don't show up.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.