Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Pivot Table - Subtotals by Quarters - Custom Calculations

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:

 

Problem.jpg

 

Appears Value Field Setting doesnt work in order to swith on Average.

 

 

Could anyone help me?

Thank you

 

1 REPLY 1
MFelix
Super User
Super User

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


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.