Forum Discussion

gardas_swathi's avatar
gardas_swathi
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago
Solved

Memory Issues with DISTINCTCOUNT

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 a...
  • amitchandak's avatar
    amitchandak
    3 years ago

    gardas_swathi , Try

     

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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

gardas_swathi , Try

 

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

  • gardas_swathi's avatar
    gardas_swathi
    Icon for Microsoft Employee rankMicrosoft Employee
    3 years ago

    Thanks Amit. That worked