Forum Discussion

dilumd's avatar
dilumd
Icon for Impactful Individual rankImpactful Individual
7 years ago
Solved

Multiply rows in DAX

Hi Everyone,   Thank you for your time, Before getting into the problem directly I'll tell you the background of this.   I have the below data table, original table has more than 100K rows (this ...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi dilumd,

     

    Please new an extra measure based on the existing [Good Sales %].

    Net Sales % = 
 PRODUCTX( VALUES('Sales Rejections'[Category]),[Good Sales %])

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi dilumd,

 

Please new an extra measure based on the existing [Good Sales %].

Net Sales % = 
 PRODUCTX( VALUES('Sales Rejections'[Category]),[Good Sales %])

Best regards,

Yuliana Gu

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
7 years ago

Hi dilumd

 

If you prefer to have everything in just one measure you could discriminate between the Total row and the others with ISFILTERED(). You would thus use your code when ISFILTERED( 'Sales Rejections'[Category]) is TRUE and v-yulgu-msft's code when ISFILTERED( 'Sales Rejections'[Category]) is FALSE (i.e., at the Total row). Something like:

 

 

NewMeasure=
IF ( ISFILTERED( 'Sales Rejections'[Category]),
     Your code here,
    @v-yulgu-msft's code here
)