Count values different than

Question

Hi, i need a daxhero!&nbsp;I need to count Orders with a specific color and without it.&nbsp;OrderIDColorProductValues111BlueProd11111BlueProd22111RedProd35111GreenProd12222RedProd24222GreenProd36333RedProd11333RedProd22333BlueProd35333GreenProd12&nbsp;For measure with color is easy:BlueOrder = CALCULATE(DIstinctCount(OrderID), Color = "Blue")Result is: 2 (ID 111 and 333)But how to write measure for orders without Blue?NoBlueOrder = ?Result shoult be: 1 (ID 222)&nbsp;i might add that it's live connection to SSAS tabular.thank you in advance

jihwan_kim · Accepted Answer

Hi,&nbsp;mic_rys&nbsp;Please kindly check the below.The sample pbix file's link is down below.&nbsp;&nbsp;Without Blue =VAR bluetable =SUMMARIZE (FILTER (SUMMARIZE ( 'Table', 'Table'[OrderID], 'Table'[Color] ),'Table'[Color] = "Blue"),'Table'[OrderID])VAR alltable =VALUES ( 'Table'[OrderID] )RETURNCOUNTROWS ( EXCEPT ( alltable, bluetable ) )&nbsp;https://www.dropbox.com/s/jw8dfslfo4zte4j/mic%20rys.pbix?dl=0&nbsp;&nbsp;Hi, My name is Jihwan Kim. If this post helps, then please consider accept it as the solution to help other members find it faster.

Forum Discussion

Count values different than

2 Replies

Related content

Counting nulls

Date Different return wrong value

How to Count Tuesday to friday Age count in different membe and Monday Age Count if different member

Count of values not accurate

Count duplicate values

OrderID	Color	Product	Values
111	Blue	Prod1	1
111	Blue	Prod2	2
111	Red	Prod3	5
111	Green	Prod1	2
222	Red	Prod2	4
222	Green	Prod3	6
333	Red	Prod1	1
333	Red	Prod2	2
333	Blue	Prod3	5
333	Green	Prod1	2