Super Groups Extended Question

Hey MattAllington, hope you are well! You have to read through the article, the column approach causes problems when you store multiple "things" in your main fact table and try to use RLS or slicers to select which set of "things" you want to look at. But, I think I solved it.

Here is what I did:

Created a disconnected table called SuperGroupMaturity:

Maturity

Bad

Good

Created the following measures:

Bad = COUNTX(FILTER(SUMMARIZE ( SuperGroups, SuperGroups[SuperGroup], "Maturity",[MinScoreMeasure] ),[Maturity]<50),[Maturity])

Good = COUNTX(FILTER(SUMMARIZE ( SuperGroups, SuperGroups[SuperGroup], "Maturity",[MinScoreMeasure] ),[Maturity]>50),[Maturity])

Then, created this measure:

Measures to Show = 
IF(
     HASONEVALUE(SuperGroupMaturity[Maturity]),
     SWITCH(
          VALUES(SuperGroupMaturity[Maturity]),
          "Bad",[Bad],
          "Good",[Good]
	 )
)

Then I could create a column chart with an Axis of "Maturity" from my SuperGroupMaturity table and "Measures to Show" as my Value.

I'm pretty sure this is solid and works. If anyone wants to confirm, I'll have to add this as an addendum to the blog post.