Measure in KPI

[KHK]

Hi,

I have created below measure formula in business view using string to count the number of rows of string.

Requirement: count(table.name = "Yes").

Written formula in Business View:

if(

    table.name = "Yes", 

    count(

        table.name

    ), 

    0

)

Case 1:

If i drag this column in Listing table am getting below values. the formula is counting 0 and 1 records, count of records  is  increasing. I want only condition satisfied records.

Case2:

 If drag this formula column in KPI , it is showing zero value. Please let me know i want to show no of records count in KPI for above condition.

[KHK]

I want to use above count of rows column in another formula column to divide the value.

[anurag · Accepted solution]

Try this formula:

sum(

if ( table.name = "Yes",  1,  0)

)

[KHK]

Thank you for your Help.