Measure / Column logic

[rav999]

Hi PBI Gurus,

I want to create a Measure that does this:

MyOrder$ = CALCULATE( IF( Products[productGroupCode]) = "AB",  [GrossOrders$] * 0.7, [GrossOrders$] ))

It does not work as the IF function does not accept the Products Table. There is a 1:M relationship between the FactOrders table and the Products table. What I want is a Measure (or a Column) that shows the GrossOrder$ that is 30% less when the ProductGroupCode is "AB". 

Existing meaure: 

GrossOrders$ = CALCULATE( SUM( FactOrders[OrderValue] ))

Thx in advance.

Rav

[MFelix · Accepted solution]

Hi @rav999 .

try the following code:

Adjusted = SUMX(Products;IF(Products[ProductsGroupcode] = "AB", [GrossOrders$] * 0.7 , [GrossOrders$]))

[amitchandak]

@rav999 , Try one of the

MyOrder$ = CALCULATE( IF( max(Products[productGroupCode]) = "AB", [GrossOrders$] * 0.7, [GrossOrders$] ))

MyOrder$ = sumx(values(Products[productGroupCode]), IF( max(Products[productGroupCode]) = "AB", [GrossOrders$] * 0.7, [GrossOrders$] ))