Forum Discussion
Aggregation without Sum
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?
jdbuchanan71 I am sorry i guess i was missing the Calculated table portion adn did not explain correctly.
Oh, for that you can just do
New Table >
New Table = SUMMARIZE ( YourTable, YourTable[Cycle.Name], YourTable[Cycle.Breakup] )Hi , thank you for the dax, but its summing the breakup still, we need it to be not summing the breakup. Do you know how i could acheive that?
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.