Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Ttable data consolidate

Hi All, Have table as mentioned below with Multiple names and Grades. Name Grade Cost Apple A 120 Apple B 90 Apple A 120 Apple B 90 Apple C 80 Apple D 75 Apple...
Need Help
  • v-xicai's avatar
    v-xicai
    7 years ago

    Hi Anonymous ,

     

    Solution1:

     

    You can just put the column Name, Grade, Cost into Table visual, then set the aggregation of cost as "Sum".

     

     

     

     

     

     

     

     

     

     

     

     

    Solution2:

     

    You can create measure like DAX below.

     

    Measure1= CALCULATE(SUM(Table1[Cost]),FILTER(ALLSELECTED(Table1),Table1[Name] =MAX(Table1[Name])&&Table1[Grade] =MAX(Table1[Grade])))

     

    Best Regards,

    Amy

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

Nathaniel_C's avatar
Nathaniel_C
Community Champion
7 years ago

Hi Anonymous ,

 

Try =sumx(values('Table1 2'[Grade]),'Table1 2'[Sum of Cost]).

 

or in PBI

Consolidate = sumx(values('Table1_2'[Grade]),SUM(Table1_2[Cost]))

 

 

 

If this helps, consider marking this as the solution! Kudos are nice too.

 

Nathaniel