Forum Discussion

Stevo164's avatar
Stevo164
Regular Visitor
8 years ago
Solved

selective sum

Hello everybody, i have the following table SALES that shows the sales per department . COD_STORE DES_STORE COD_DEPARTMENT DES_DEPARTMENT SALES DATE 0002 STORE_1 0002051 DEPARTMENT_1...
  • Stevo164's avatar
    Stevo164
    8 years ago

    I solved it creating the following measures:

    • Check_tot1= CALCULATE(COUNT('Sales'[Sales]);'TRANSCODING_DEP_SEG';'TRANSCONDING_DEP_SEG'[CONDITION_RED]="1")
    • Sales_Dep13= CALCULATE(SUM('SALES'[SALES]);'SALES'[DES_DEPARTMENT])="13")

     

    Whit the two new measures I've finally created the measure that can solve my problem:

    • Sales_Seg = IF('SALES'[Check_tot1]>0;'SALES'[Sales_Dep13];SUM('SALES[SALES]))

     

    Thanks everyone for the support.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Stevo164,

Create measure using DAX below.

Measure  = IF(MAX(TRANSCODING_DEP_SEG[CONDITION_RED])=1;MAX(Sales[SALES]);SUM(Sales[SALES]))




Regards,
Lydia

Stevo164's avatar
Stevo164
Regular Visitor
8 years ago

Thank you Anonymous for your kind answer, but it's not working for me, because I have the sales per day and it will show the max sales in a day.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Stevo164,

    I make a test using your sample data, you can check this PBIX file. If you still have questions about the DAX, please share your PBIX file via Private Message, I will test it in my environment.

    Regards,
    Lydia