79635945

Date: 2025-05-23 17:06:08
Score: 1
Natty:
Report link

I've found an alternate workaround in DAX that relies on the structure of my source data:

MajorMinor = DISTINCT(SELECTCOLUMNS(Data, [Major], [Minor]))

where I can guarantee that all of the possible products are present in my data. This is just as fast as it ought to be.

Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Self-answer (0.5):
  • Low reputation (0.5):
Posted by: Sort of Damocles