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

Maybe somthing along these lines:

 

55.Table.test =
SELECTCOLUMNS('22_Price_Daily',"Name",'22_Price_Daily'[Cycle.Name],"Breakup",DISTINCT('22_Price_Daily'[Cycle.Breakup]))
 
 
But its giving me error. " A table of multiple values was supplied where a single value was expected"