Counting the Value Inserted Through a Measure in a Column of Table Object

[sban]

Dear All,

I have a Column in my Table Object which is a Calculated Value through a Measure containing an if expression.

The expression is of the format below: if(aggr(count(....)), 'X','Y')

I want to display a KPI which tells me how many X and how many Y are present in my table object, based on the selections. 

How can this be achieved in the KPI?

Thanks and Regards.

[MayilVahanan · Accepted solution]

Hi @sban 

Try like below

X values: Sum(if(aggr(count(....)), 1,0)

For Y values, change the condition in If statement, then do the same .

[sban]

Thank you Mayil. This is working perfectly.