Forum Discussion

dilumd's avatar
dilumd
Impactful 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
Microsoft 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
    Community 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
)