Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Greg_Deckler
Super User
‎10-05-2021 08:42 AM

Microsoft Hates Greg's Quick Measures

Microsoft Hates Greg's Quick Measures

gerg.png

Image concept and credit: Rocket Deckler

Introduction

Today I am announcing the availability of a new External Tool for Power BI Desktop, "Microsoft Hates Greg's Quick Measures" or MSHGQM for short. This tool more than doubles the number of Quick Measures available in Power BI Desktop alone and most calculations support the creation of either DAX measures or calculated columns so really MSHGQM triples the number of quick, easy calculations you can create.

 

The Birth of MSHGQM

So, despite the fact that I have contributed nearly 200 quick measure formulas to the Power BI Community's Quick Measure Gallery, Microsoft has never once been so inclined as to base one of the Quick Measures in Power BI Desktop on one of my submissions. Other Quick Measures have made it, like Chris Webb's Star Rating and Daniil Maslyuk's Simple Linear Regression. Never one of mine though. But am I bitter? A little...I'm a little bitter, I'm not gonna lie. So what is one to do when life hands you lemons? Well, you can make lemonade or...you can use gain of function research to bioengineer a new, novel bacteria that attacks the photosynthetic respiratory systems of lemon trees in order to wipe out lemons from the face of the earth and henceforth be forever impervious from receiving sour fruit. What? Too soon? In any event, figuratively speaking, I took the latter approach. And thus, after a weekend of teaching myself how to code a C# WPF application, MSHGQM was born.

 

Are You Serious?

Oh yes, I am quite certain that Microsoft hates my quick measures. What are you going to do? Some people hate cans, some people hate turtles and some people at Microsoft obviously have a vitriolic hatred of my DAX code. But, I realize you probably have a whole host of questions. I will try to anticipate those questions and answer them here:

 

Where can I download Microsoft Hates Greg's Quick Measures?

Why, you can download it right here from GitHub.

 

Is this a joke? Does it really exist?

That's two questions, but OK. Yes, unlike my prank 150th Quick Measure Gallery submission, MAGIC!, this tool actually really does exist and works just as described. See, here is an un-doctored screen capture:

MSHGQM.png

In fact, if you had attended my last CAMLPUG meeting, you would have actually seen a pre-working version of the tool. My son Rocket is still editing the video for distribution but I'll get it posted as soon as I can.

 

Is the code as garbage as that interface?

Oh yes, I can assure you that the code is absolute garbage. But it works. Did you miss the part of this being my first ever C# WPF application and that I effectively coded it in a weekend? MSHGQM is actually an extremely hacked up version of the most excellent Metadata Translator tool by Kay Unkroth. Other than a few of my classes still being called Language and TranslationGroup though, not much of Kay's code remains sadly. But, a deep, heartfelt thanks to Kay. I learned a tremendous amount studying your code and MSHGQM wouldn't exist without that knowledge.

 

Why the name Microsoft Hates Greg's Quick Measures?

Well I had a strict set of specific criteria for naming this tool. That criteria was as follows:

  1. Convey how much Microsoft hates my quick measure DAX code
  2. Make the name as long as possible
  3. Absolutely and utterly thwart any and all attempts at acronization

Thinking of the perfect name that fit all three criteria took many hours of laborious thought and "ideation", I assure you.

 

Is the code open source?

No, the code is not open source.

 

What!?!!?? That's blasphemy! How can your code NOT be open source?!?!?!?!!!?

Because it's not.

 

Look, I have spent far, far too much time and energy excoriating open source to just roll over and release a piece of open source software. It's just not going to happen. Well, there is one path, but you aren't going to like it.

 

I realize that you are probably thinking that this sorta makes me like the kind of guy that would grab a handful of extra plastic bags every time he visits the grocery store and immediately toss those plastic bags into the nearest river or stream with the express intent of maximizing the total amount of worldwide turtle carnage. OK...fair. I actually happen to be that kind of guy...like, exactly that guy #oddlyspecific. But hey, at a young age my parents were tragically killed in front of me during a freak sea turtle mating accident. So, who are you to begrudge me a little revenge? The point is, the code is not open source.

 

Now, I have provided the code to @Mike_Carlo at powerbi.tips so that he can inspect it for "malicious" code. As long as "malicious" does not mean "an incomprehensible mess", we should be good. Fantastic website BTW. I am working with Mike to get the tool included in Business Ops because I'm too lazy to write an installer of my own and Business Ops is really cool and legit.

 

But wait, doesn't that make you a complete and utter hypocrite for using open source code to create your own closed source program?

Actually...it kind of goes along with and proves everything I have pretty much ever said about open source code. So...yeah, I'm good with it. Look, my program has all of the same hallmarks as 99.99999% of all open source software. It's kinda garbage, it isn't innovative, it's inefficient, it's generally inferior to what it is imitating, its storage is contributing to global warming and it's free. So, 6 out of 7 ain't bad. You really haven't been reading my stuff, have you?

 

Why didn't you use Python instead of C#?

Because...meh.

 

What are the future plans for MSHGQM?

Well, the current tool is what I would consider an alpha version. The goal for the beta version is to cleanup all of the code and double the number of quick measures available. The beta is still going to be based on my own homegrown JSON DAX quick measure description format and necessary code behind for each quick measure. Probably take me a couple months.

After the beta, my goal is to try to use Mike Carlo's nifty new DAX template creation tool to create DAX templates for my quick measures. The end goal is to try to make the entire interface, including the configuration interface for quick measures/columns, completely data driven so that you can add new quick measures simply by dropping a DAX template into a directory. That might take some time.

 

Conclusion

If they won't let you play, take your ball and go home. Destroy the ball with extreme malice and prejudice. Invent a new ball. Invent a new game. Boldly declare victory even though nobody uses your ball or likes your stupid game.

 

Many thanks to my son Rocket for the image and have you checked out his crazy awesome video yet? The kid has some talent.

Labels:
Comments
Anonymous
‎10-12-2021 06:29 AM

I keep getting "Unable to launch external tool. The executable was not found" errors, even though I'm fairly sure I set the path correctly in the .json file.

0
Super User
‎10-13-2021 04:03 AM

@Anonymous Are you using \\ for a single \? Backslashes have to be escaped in JSON so, for example, my path looks like this:

 

  "version": "1.0",
  "name": "Microsoft Hates Greg Debug",
  "description": "Microsoft doesn't like my quick measures.",
  "path": "C:\\Users\\gdeckler\\source\\repos\\MSHGQM Alpha\\MicrosoftHatesGregsQuickMeasures\\bin\\Debug\\MicrosoftHatesGregsQuickMeasures.exe",
  "arguments": "\"%server%\" \"%database%\"",
0
Anonymous
‎10-13-2021 05:43 AM

Thanks, I had a typo in the path. Working now! 🙂

 

 

Super User
‎10-13-2021 02:29 PM

@Anonymous No one is more surprised than me! 😄 You might be the first other person to get it running!!

Super User
‎10-13-2021 04:13 PM

@Greg_Deckler mate, the name: absolutely hilarious!  I genuinely laughed out loud, shed a slight tear, and thought to myself, "There is no freaking way that Microsoft Hatest Greg Deckler." They'd be maniacs! 

 

Keep up the stupidly amazing awesomeness mate. This is next level!

Helper I
‎03-30-2023 04:08 AM

Thank you for this tool.  I've really enjoyed your cookbook and downloadable chapter files.  You are a DAX wizard.  I try and push stuff to the source system or Power Query if I can as I'm no magician.

Could I ask that the next version of MHGQM can run like a portable application?
I believe Tabular Editor allows this and the ask is because a lot of organizations don't support the suite of external tools that plug into Power BI

Thanks again and keep ranting