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’
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?
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?
- Find Trained Employees who left the Company – DAX Challenge
- Find Unique Travel Dates – DAX Challenge
- Find Days before the Earliest Date – DAX Challenge
- Separate Managers and Employee Names – Power Query Challenge
- Separate Numbers from Text – Power Query and Excel Challenge
.
Learn DAX from Scratch !!!
A comprehensive course to learn DAX step by step and solve real time problems in Power BI.
DOWNLOAD THE COURSE OUTLINE | ENROLL IN THE COURSE
