Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I have two dimensions
1. Product Category
2. Product Name
So the purpose is.. if user has only made selection on Product Category level instead of Product Names then the table should show count of total categories and as soon as user filters any product Name then that expression should change to count product names.
Something like this:
If Product Name Selection is > 0 then count(Distinct([Product Name])) else Count(Distinct([Product Category]))
What is the best way to write that expression?
Thank you.
May be like this
If(GetSelectedCount([Product Name]) > 0, Count(DISTINCT [Product Name]), Count(DISTINCT [Product Category]))
May be like this
If(GetSelectedCount([Product Name]) > 0, Count(DISTINCT [Product Name]), Count(DISTINCT [Product Category]))
Thanks Sunny