Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

SUMMARIZE Function

Halo People   So the summarize function dont seem to work as expected, see below. The error does not make sense, since the expression is merely a sum(table[tonnes column) and I just saw someone in ...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    I think you are trying to create this as Measure, Navigate to Modelling -> New Table, ad use the formula there.

     

    Thanks

    Raj

Anonymous's avatar
Anonymous
Not applicable
8 years ago

I think you are trying to create this as Measure, Navigate to Modelling -> New Table, ad use the formula there.

 

Thanks

Raj

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hello,

     

    I have two tables like TBL and CUST. I have created the CUST table using the DAX.

    CUST=
    ADDCOLUMNS(
    SUMMARIZE(FILTER(TBL,NOT(TBL[Account])=BLANK()),TBL[Account ],
    "Sale",CALCULATE(SUM(TBL[Sale Amount]),FILTER(TBL,TBL[Ind]="Yes"),FILTER(TBL,TBL[Ind2]="Yes" && NOT(TBL[Code]) IN {"4"} ))
    ),
    "Grp",
    IF ( [Premium] >=0 && [Premium]<100, "0-100",IF ( [Premium] >=100&& [Premium]<500, "100-500",IF ( [Premium] >=500 && [Premium]<1000, "500-1000M",IF ( [Premium] >=1000, "1000+" )))))
    Now, I have created a relationship between those two tables using "Account" column and created a Cust Grp column in TBL using Related(CUST[Grp]). I want build a customer count based on grouping. 
    Problem:
    Counts were fine when there were no filters applied but when I apply a filter on TBL tables Sale amount in CUST table is not filtering(I selected filtering as Both direction). As a result, counts in the group are not being calculated properly. 
    For example, if I filter country in TBL to the "USA" the premium in the CUST table is not changing.
     
    Please help me out!!!!
    Thanks in advance!!!!!