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
I have created a Matrix View in Power BI table as i wanted dynamic output based on the weeks selection. Here everything is working as i wanted except the Total - i need the average instead of total as highlighted in yellow colour. Can you please help.
Thanks
Soji
=averagex(summarize(Factable,table[Emirate],DateTable[Week]),[Amount])
Thanks for all responses.
I have managed to find the solution by creating a quick measure for the average.
Hi Amit,
I have manually added the average in the sample data which i shared but in BI i am getting total instead of average.
Thanks
@soji , Assume you have sum measure
the create measures
average measure 1= [sum measure]/distinctcount(Table[Week])
average measure 2= [sum measure]/distinctcount(Table[emirate])
and use below measure in matrix
Switch( True() ,
isfiltered(Table[Week]) && not( isfiltered(Table[Emirate])) ,[average measure 1],
not(isfiltered(Table[Week])) || isfiltered(Table[Emirate]) ,[average measure 2],
[sum measure]
)
@soji , Total seem like average, what is the problem?
isfiltered can help you in switching the total?
refer: https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
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.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |