Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have an requirement of restrict measure if completed is 100% then dimensions should show blank.
That would require each dimension to be an If() statement and a measure since you are conditioning it on a measure:
If(Sum(need)/sum(done)=1, dimension,'')
What you posssibly want to do is only show rows that are incomplete?
Add a measure with set expression - Only({$<[key field]={"=Sum(need)/sum(done)=1"}>} [key field])
Dear David,
Thank you for your Reply.
I no need to hide whole row.