Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Aggregation without Sum

Hi All,   I was wondering if you can help my in this part. Im trying to aggregate some numbers without summing them. So for each cycle.Name i want to have each type of available numbers for it with...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    5 years ago

    Anonymous  the DAX I gave you should generate the new table you are looking for.  When you say "new table" you mean a new calucated table that is in your data model yes?

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

jdbuchanan71 

 

Thank you very much for the prompt reply. But i would need to have it made in dax as the numbers im looking for are basis used for another calculation behind the scenes. Visualy i dont need to display them anyware. Would you know how to produce same results by using dax? 

 

THnak you & Kr

jdbuchanan71's avatar
jdbuchanan71
Super User
5 years ago

I think this will give you what you are looking for.

Cycle Breakup Measure = 
SUMX (
    GROUPBY ( YourTable, YourTable[Cycle.Name], YourTable[Cycle.Breakup] ),
    YourTable[Cycle.Breakup]
)

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    jdbuchanan71 

     

    Hi thanks again for looking into it. Im more looking for the first example you provided at the begining but would need it in the form of a Calculated table i dont need the Sum of all the numbers like your last example. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      jdbuchanan71  I am sorry i guess i was missing the Calculated table portion adn did not explain correctly. 

      • jdbuchanan71's avatar
        jdbuchanan71
        Super User
        5 years ago

        Oh, for that you can just do 

        New Table > 

        New Table = SUMMARIZE ( YourTable, YourTable[Cycle.Name], YourTable[Cycle.Breakup] )