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.
Hello Everyone,
I am quite new with DAX and PowerPivot.
I built all my formulas using dax in Pivot, but now I have problem with Subtotals by quarters / Grand Total with "Not Effect" Row:
1) I want to show by Quaters 2000 (Average of Months) instead of Total (6000)
2) I want to show 2000 in Grand Total instead of (23600)
here is picture:
Appears Value Field Setting doesnt work in order to swith on Average.
Could anyone help me?
Thank you
Hi @Anonymous ,
The information you provide is difficult to make a good answer can you share a sample of the file.
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering 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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |