A while ago I got stumped by a problem somewhat like the one that I am going to share. On the face of it, it looks so simple but there is a lot going on under the hood.

See if you can you get your head around this one, Give it a shot!

 

Consider this table called ‘Data’

The SUMX DAX Puzzle

And these 2 measures

SumofNumber = SUM ( Data[Number] )
SUMXofNumber = SUMX ( Data, [SumofNumber] )

 

Question – if I make the following pivot table, what will be the result of the two measures?

The SUMX DAX Puzzle

 

Just one rule..

You are not allowed to recreate the 2 measures in Excel / Power BI, see the result and paste it here. You should solve this with pen-n-paper. Post your answer and the reasons for your answer in the comments.

Cheers

 

Want more of these?

  1. Find Trained Employees who left the Company – DAX Challenge
  2. Find Unique Travel Dates – DAX Challenge
  3. Find Days before the Earliest Date – DAX Challenge
  4. Separate Managers and Employee Names – Power Query Challenge
  5. Separate Numbers from Text – Power Query and Excel Challenge


Topics that I write about...






Download Smart Ebooks on
Excel and Power BI