Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi PBI Gurus,
I want to create a Measure that does this:
Solved! Go to Solution.
Hi @rav999 .
try the following code:
Adjusted = SUMX(Products;IF(Products[ProductsGroupcode] = "AB", [GrossOrders$] * 0.7 , [GrossOrders$]))
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @rav999 .
try the following code:
Adjusted = SUMX(Products;IF(Products[ProductsGroupcode] = "AB", [GrossOrders$] * 0.7 , [GrossOrders$]))
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português@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$] ))
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |