Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
Could you please help me on below requirement.
In the below Table I have Taken
Dimension as [Internal ID]
Measure as
if(
ISNULL(AGGR(
if(Match([Sales Product],'TV'),[Performance External ID],
if(Match([Sales Product],'Mobiles'),[Performance ID])),
[Internal ID])),count([Internal ID])
The requirement is I have to show 2966 count in KPI. How to change the above expression for getting 2966 count with above table settings.
Please help me on this.
Try this
Sum(Aggr(
If(IsNull(Aggr(
If(Match([Sales Product],'TV'), [Performance External ID],
If(Match([Sales Product], 'Mobiles'), [Performance ID])), [Internal ID])), Count([Internal ID])
, [Internal ID]))
Try this
Sum(Aggr(
If(IsNull(Aggr(
If(Match([Sales Product],'TV'), [Performance External ID],
If(Match([Sales Product], 'Mobiles'), [Performance ID])), [Internal ID])), Count([Internal ID])
, [Internal ID]))