Memory Issues with DISTINCTCOUNT

gardas_swathi — Mon, 10 Oct 2022 21:24:50 GMT

HI ,

I am having issues with using DISTINCTCOUNT /COUNTROWS function for my tabular model. Both of them are giving memory related errors. The Fact Table has 500k records and the AggMeasure is an existing measure.

I need to just find the distinct count of Materials where AggMeasure>0 based on user filtering. Is this possible? Please help

Coverage:=CALCULATE(DISTINCTCOUNT('Material'[ID]),FILTER('Fact',[AggMeasure]>0))

Coverage2:=
COUNTROWS(SUMMARIZE(FILTER('Fact',[AggMeasure]>0),'Material'[ID]
))

Re: Memory Issues with DISTINCTCOUNT

amitchandak — Tue, 11 Oct 2022 01:26:59 GMT

gardas_swathi , Try

COUNTROWS(FILTER(Values('Fact'Material'[ID]'),[AggMeasure]>0)
)

Re: Memory Issues with DISTINCTCOUNT

gardas_swathi — Mon, 17 Oct 2022 04:38:44 GMT

Thanks Amit. That worked

topic Memory Issues with DISTINCTCOUNT in DAX Commands and Tips

Memory Issues with DISTINCTCOUNT

Re: Memory Issues with DISTINCTCOUNT

Re: Memory Issues with DISTINCTCOUNT