Agg table with multiple levels in fact table

[codyraptor]

I have 1 fact table that has 2 levels of granularity.  ID > Item.  I need to create an aggregate table in a composite model.  Ive produced the table...but my ID counts are much too high of course because of the duplicates in my group by.  Question...do you have to establish an agg table for every level in the fact table to account for distinct counts of ID for example...if the source fact table is set at a different granularities?  OR...is there a way to do this in dax and still hit the agg? 

[amitchandak · Accepted solution]

@codyraptor , Based on what I got it. When you define aggregates you can leave it out if for distinct count.

Also for distinctcount try like

countrows(values(Table[Column]))

or

countrows(Summarize(Table, Table[Column]))