Count distinct dates

[satishkurra]

Hi Team

I'm having an expression in straight table as Count(distinct SalesDate). This is producing me the count I need. Also, the Sales Date is of MM/DD/YYYY format.

Now I'm trying to filter the table to show the records that the count of above expression is >= 300.

Can someone help me with this?

[Kushal_Chawda · Accepted solution]

@satishkurra  try below

 =sum(aggr(if(Count(distinct SalesDate)>300, Count(distinct SalesDate),Dim1,Dim2)) // Dim1 & Dim2 are staright table dimensions. You need to include all dimensions.

or

Count(distinct {<Primary_Key={"=Count(distinct SalesDate)>300"}>}SalesDate)

[satishkurra]

@Kushal_Chawda : Below expression is working but it is showing the value with 0 as well in the table

2nd expression did not work

sum(aggr(if(Count(distinct [Sales Date]) >= 300, Count(distinct [Sales Date])),[Actual Name],[Product Name]))

[Kushal_Chawda]

@satishkurra  You need uncheck "Include zero values" option

[satishkurra]

@Kushal_Chawda 

Yes it is unchecked. The issue is I have some other measures which are 0 and it is not working