Forum Discussion
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...
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.
Hi Stevo164,
Is there an indicator/column that indicates what should be red? If yes, you could use that condition as filter.
For example: Calculate(Sum(Table[Sales]), filter(Table, Table(Condition)....)
Does this help?
Hi Anonymous,
thank you for your help.
I've the following tables
- SALES with the sales per department
- TRANSCODING_DEP_SEG which defines the departments as a part of a segment
I've created a new table called DEPARTMENTS which defines what departments are red by the column CONDITION_RED
COD_STORE DES_STORE COD_SEGMENT DES_SEGMENT COD_DEPARTMENT DES_DEPARTMENT CONDITION_RED 0002 STORE_1 0002A23066 SEGMENT_1 0002060 DEPARTMENT_4 0 0002 STORE_1 0002A23066 SEGMENT_1 0002066 DEPARTMENT_8 0 0002 STORE_1 0002A24062 SEGMENT_2 0002061 DEPARTMENT_5 0 0002 STORE_1 0002A24062 SEGMENT_2 0002062 DEPARTMENT_6 0 0002 STORE_1 0002A24062 SEGMENT_2 0002064 DEPARTMENT_7 0 0002 STORE_1 0002A27051 SEGMENT_3 0002051 DEPARTMENT_1 0 0002 STORE_1 0002A27051 SEGMENT_3 0002052 DEPARTMENT_2 0 0002 STORE_1 0002A27051 SEGMENT_3 0002053 DEPARTMENT_3 0 0002 STORE_1 0002A27051 SEGMENT_3 0002070 DEPARTMENT_9 0 0002 STORE_1 0002A27051 SEGMENT_3 0002071 DEPARTMENT_10 0 0002 STORE_1 0002A27051 SEGMENT_3 0002072 DEPARTMENT_11 0 0002 STORE_1 0002A27051 SEGMENT_3 0002073 DEPARTMENT_12 0 0002 STORE_1 0002A27051 SEGMENT_3 0002080 DEPARTMENT_13 1 0002 STORE_1 0002A27051 SEGMENT_3 0002081 DEPARTMENT_14 1 0002 STORE_1 0002A27051 SEGMENT_3 0002082 DEPARTMENT_15 1 0002 STORE_1 0002A27051 SEGMENT_3 0002083 DEPARTMENT_16 1 0002 STORE_1 0002A27051 SEGMENT_3 0002084 DEPARTMENT_17 1 0002 STORE_1 0002A27051 SEGMENT_3 0002085 DEPARTMENT_18 1 0002 STORE_1 0002A27051 SEGMENT_3 0002086 DEPARTMENT_19 1 0002 STORE_1 0002A34099 SEGMENT_4 0002099 DEPARTMENT_20 1 I've tried your solution but the result isn't what I need
CALCULATE(SUM(SALES[SALES]);DEPARTMENTS[CONDITION_RED]="1")
COD_STORE DES_STORE COD_SEGMENT DES_SEGMENT SALES 0002 STORE_1 0002A23066 SEGMENT_1 0002 STORE_1 0002A24062 SEGMENT_2 0002 STORE_1 0002A27051 SEGMENT_3 $ 19.067.811,00 0002 STORE_1 0002A34099 SEGMENT_4 $ 2.495.266,00