I need know if I can change the Total Value for AVG, but in the same column that totals are showing.
I've try with these formula
1.- S = SUM(FACT_SALES_ST[Net])
2.- AVG = AVERAGEX(VALUES(FACT_SALES_ST[Business_type]); [S])
and the results are this,
So, i.e, in the second column, AVG, I have
same value for Net. well, that is incorrect, AVG for those values is 8.377.596,3
So, I need the value 8.377.596,3 (AVG) in the same column that Total
avg instead total..
Go to Solution.
can u share the link of sample PBIX file. I have same senario.
You need to use column in table rows instead calendar'[Date].[Month])
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.