Obtaining a Key Value to reflect Number of Stores On Target

[President]

I can't share the actual data because its confidential, but please see excel file with a simple example of the data I have.

All I am trying to do is to get the total number of stores On Target in terms of sales and place that number in a Key Value.

Store - Name of the store

Actual Sales - Sales that have been carried out

Target Sales - The target sales amount or the day

Target Ratio = Actual Sales/Target Sales

Target Reached - This is a calculated item that I created to return "On Target" or "Not On Target" depending if the ratio is >= 1

Thanks

[Sam_SAS · Accepted solution]

Hello,

There might be better ways of doing this, but I think this should work:

1. Create a distinct count of Store. You could do this by right-clicking Store in the Data pane, selecting New Calculation, and then selecting Distinct count.

2. Assign the new Distinct Count measure from step 1 to a Key Value object.

3. Assign a filter to the Key Value, based on your Target Reached calculated item. Select "On Target".

The Key Value should display the number of stores that are on target.

Let us know if that helps!

Sam

[President]

Hi @Sam_SAS 

Thanks so much for the assistance.

I am going to give a go this morning, then I will update you.

Kind Regards,

Fungai Jani

[President]

Good morning @Sam_SAS 

It looks like it worked, thanks a lot for the assistance.

Kind Regards,

Fungai Jani

[Sam_SAS]

Great! Thanks for letting us know 🙂

Sam