Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good Morning,
I need to use if statement and count in same expression. When using the following expression i'm getting no data.
=If(Identity = 'A', count(distinct{<Identity = {'A'}>}[ID]), If (Identity = 'B',count(distinct{<Identity = {'B'}>}[ID])))
the syntax is := count (if(condition,value))
Try putting the distinct after the set expression:
=If(Identity = 'A' , count({<Identity = {'A'}>}distinct [ID]),
If (Identity = 'B' , count({<Identity = {'B'}>}distinct [ID])))
Or you can create 2 expressions
A:
count({<Identity = {'A'}>}distinct [ID])
B:
count({<Identity = {'B'}>}distinct [ID])