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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
daxlim0
New Member

Trying to figure out the results of two DAX measures.

Given two measures A and B with table given below (Mini - Table). Measures A and B are shown below. 

 

Why does measure A give me an answer of 8? 

The answer 8 for measure A is confusing me as its not doing the average like i'm expecting. 

 

I understand that there is context transition happening for each shift inside the CALCULATE function.  I am expecting the answer to be 4 for measure A since there are no filters applied in the table. 

 

Can someone shed some light? Its driving me insane. 

 

 

daxlim0_0-1670725437768.png

 

Measure A

daxlim0_1-1670725465665.png

 

 

Measure B

 

daxlim0_0-1670726540907.png

 

 

 

daxlim0_3-1670725533282.png

 

1 ACCEPTED SOLUTION
daxlim0
New Member

Figured out the answer to my own question. 

View solution in original post

3 REPLIES 3
daxlim0
New Member

Figured out the answer to my own question. 

Jihwan_Kim
Super User
Super User

Hi,

I am not sure how your datamodel looks like, but one of ways to check is, please check if one column is sorted by other column in MINI table.


If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

I'm not sure how sorting is going to change the measure answer. 

 

The table in the data model is as follow:

 

daxlim0_0-1670742750052.png

 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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