Forum Discussion
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...
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?
Oh, for that you can just do
New Table >
New Table = SUMMARIZE ( YourTable, YourTable[Cycle.Name], YourTable[Cycle.Breakup] )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?
You are 100% correct. Its my mistake. I just checked the table and it works perfectly. I overlooked that since the numbers on breakup are numerical values they get sumed up automaticaly when creating a table on a page.
Many thanks for your help. Greatly apreciated.
Kind regards.