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!

Dax Calculation Average YTD

1.PNG

 

hi , i really want this KPIs to be on the right track. 

what i want is : 

*Calculation of Average YTD , on Table and Bar Chart. 

 

**If i click the filter on Jan + Feb , there will the Average YTD on Bar Chart , And Table Visalization. 
I wish on my table , I have Average YTD at the end of the table ( YOu see the Blank square i draw ) ,there should have  an Average YTD for all KPI. 

 

** on the Exisiting Bar Chart , the % TY VS LY , aren't meet the expectation. what i want is the average YTD , this should be the right Data. 

Anyone can help me on this ? ??? 

Status: New
Comments
Anonymous
Not applicable

Hi - using the PBIX you uploaded for another similar question, I can see that you already have the summary YTD variance.  The reason it looked wierd was because multiple years were included in your filter and so it was summing the measures for the two years together.  Once filterd down to just 2018 it looks fine, uncluding the variances to 2017.

 

Untitled.png

Chanleakna123
Post Prodigy

Hi @Anonymous the Grand total originated from BI Metrix is YTD ( Sum all together ) 

it doesn't show the average YTD.  

Any idea on this ? 🙂 

Chanleakna123
Post Prodigy

Hi @Anonymous actually , i want all data to be in average at the grand total by not summing together , 

the data summing together is not what i want . 

 

Do you have any idea on this ?