Forum Discussion

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
3 years ago
Solved

No CACULATE challenge

For those haters of CALCULATE like Greg_Deckler, I challenge you to create a measure without CALCULATE that performs anywhere close to the same speed as this very simple measure that switches to an i...
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

tamerj1 Slick, way better than my revision in my video I made last night.

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Greg_Deckler 

Wow!

Thank you for mentioning me in your video ☺️

My name is Tamer Juma by the way and we are connected in LinkedIn actually you replied to my comments there couple of times. 

Note: I fixed the wrong total by simply replacing the outer SUMX with MAXX

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    3 years ago

    tamerj1 Yep, I saw that after the video went up. I posted the PBIX out on MicrosoftHatesGreg on github with the revised measure that corrects the subtotals. Absolutely, of course I'm going to mention you! You're one of the stars of the show! And nice to meet you Tamer Juma! Sorry, never put the two together before or my memory is failing me! But, it did let me work in the SwizzleStick420 joke!