DAX help with a conditional classifer

Question

I may be making this more difficult than needed....&nbsp;I have a data table that I would like to filter with complex conditioonsn and then classifiy into a measure for pivot reporting.&nbsp;See the below example.&nbsp; DimINS may be extra\unneeded.&nbsp; I have defined the measures I am looking to pivot with the report example at the bottom.&nbsp;Thanks for helping in advance.&nbsp; It all seams to foggy when it really should be simple dynamic conditions.&nbsp;RunningTbl&nbsp;&nbsp;&nbsp;dimT_Bunch&nbsp;dimINS&nbsp;&nbsp;&nbsp;&nbsp;InvoiceRunCodeInsid&nbsp;RuncodeBunch&nbsp;InsidName&nbsp;&nbsp;&nbsp;123104Red&nbsp;TT5&nbsp;RedRed Inidustry&nbsp;&nbsp;&nbsp;123TTBlue&nbsp;TF5&nbsp;BlueBlue Induistry&nbsp;&nbsp;&nbsp;123TGBlue&nbsp;1043&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;124104Blue&nbsp;1253&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;124101Blue&nbsp;1013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;124TTBlue&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;125104Red&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;125127Red&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;125TFBlue&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;126104Red&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;127104Blue&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Reflection = 'Count num of Runcode = "104" and Classify invoice by red or blue bases on Bunch code = "5"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Mirrors = Count num of Runcode = "104" where invoice not classifed by Bunch Code ="5" use Insid&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Straight 104 ReflectionsMirrors&nbsp;Bunch 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Red301&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Blue240&nbsp;3&nbsp;&nbsp;&nbsp;&nbsp;

v-sihou-msft · Accepted Answer

jrwjr_eng
&nbsp;
I still can't understand your logic. In your Dim T_Bunch table, your RunCode and Bunch is 1-to-1 relationship.
&nbsp;
What do you mean "RunCode = 104" AND "Bunch Code=5"?
&nbsp;
If you are counting the invoices which matches your condition, can you explain why you get those results in the bottom table?
&nbsp;
Regards

Forum Discussion

DAX help with a conditional classifer

2 Replies

Related content

Fabric + Purview (Data Classification)

Conditional classification

Microsoft data classification and PowerBI

Rank with conditions

Conditional Formatting

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