DAX help with a conditional classifer

[jrwjr_eng]

I may be making this more difficult than needed....

I have a data table that I would like to filter with complex conditioonsn and then classifiy into a measure for pivot reporting.

See the below example.  DimINS may be extra\unneeded.  I have defined the measures I am looking to pivot with the report example at the bottom.

Thanks for helping in advance.  It all seams to foggy when it really should be simple dynamic conditions.

RunningTbl				dimT_Bunch		dimINS
Invoice	RunCode	Insid		Runcode	Bunch		Insid	Name
123	104	Red		TT	5		Red	Red Inidustry
123	TT	Blue		TF	5		Blue	Blue Induistry
123	TG	Blue		104	3
124	104	Blue		125	3
124	101	Blue		101	3
124	TT	Blue
125	104	Red
125	127	Red
125	TF	Blue
126	104	Red
127	104	Blue
		Reflection = 'Count num of Runcode = "104" and Classify invoice by red or blue bases on Bunch code = "5"
		Mirrors = Count num of Runcode = "104" where invoice not classifed by Bunch Code ="5" use Insid
			Straight 104	Reflections	Mirrors		Bunch 5
		Red	3	0	1		0
		Blue	2	4	0		3

[v-sihou-msft · Accepted solution]

@jrwjr_eng

I still can't understand your logic. In your Dim T_Bunch table, your RunCode and Bunch is 1-to-1 relationship.

What do you mean "RunCode = 104" AND "Bunch Code=5"?

If you are counting the invoices which matches your condition, can you explain why you get those results in the bottom table?

Regards

[jrwjr_eng]

Yes, Invoice counts is the goal.

Invoice Units = CALCULATE( COUNTX( FILTER('RunningTbl', 'RunningTbl'[bc]="104"), 'RunningTbl'[invoice]))

For unit counts... I need to aggregate the data table by a grouping (for example of Invoice 123 = 104 AND TG, then grouping 5 and classfied by the INSID color of the TG = Blue)

I went to look for SQL examples and found a DAX Dynamic Segmentation that is an example of a numeric classifier.  If I can port this over from a numeric range to a alpha index in a parameter table, I may have a way.

http://www.daxpatterns.com/dynamic-segmentation/

https://powerpivotpro.com/2014/11/new-twist-for-dynamic-segmentation-variable-grain-range-selection

I know I am making this harder than it needs to be.

In plain english, I want to test Invoices and if they known combnations of RunCodes to classify them as Reflections or Mirrors.  Then count\total classification as the Insid color for the RunCodes in t_group 5.