Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
@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 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)
@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]))
@satishkurra You need uncheck "Include zero values" option
Yes it is unchecked. The issue is I have some other measures which are 0 and it is not working