Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have an issue when I try to use a claculation to display a dimension. I have a table with a list of products and and count measure of the amount of task id's associated with the product. This works fine, however I want to display a table of products where the count = 0. To do this I used the expression IF(COUNT(Task_ID) = 0,Product_Code).
To me this has always worked when using calculated dimensions, what am I doing wrong here?
We cannot use aggregate function in dimension,its meant for Measure. however you want to use in dimension then
use aggr function
IF(aggr(COUNT(Task_ID),field1,field2,..) = 0,Product_Code).
where field 1 field 2 are field by which you want to aggr.
without aggr it will not work
I don't prefer to use as Calculated dimension because it degrades the performance of the object. instead, can't you do that in measure?
Hi @neil-devlin , as @Anil_Babu_Samineni mentioned, We prefer not to use calculated dimensions since they can slow down performance. Instead, can you try doing this in a measure?
You can use a normal dimension along with a measure like COUNT(Task_ID) = 0
to filter and show only the products where Task_ID is 0.
Alternatively, you could also use a Master Dimension or Master Measure for this.