Filter

[Nikki]

Hi

I have 1 table with columns called "forecast days" "date" "resource name" and so on

i set the page filter to allow the user to select the month

i then need a number figure which does the following:

tell me the number of resources that have more than 20 days assigned (which is forecast days) to them as a sum for that month

i cant seem to get any number displaying other than 1...

please help

thanks

Nikki

[Eric_Zhang]

@Nikki

For me, the requirement is not clear. Could you please post some sample data and

---

@Nikki wrote:

Hi

I have 1 table with columns called "forecast days" "date" "resource name" and so on

i set the page filter to allow the user to select the month

i then need a number figure which does the following:

tell me the number of resources that have more than 20 days assigned (which is forecast days) to them as a sum for that month

i cant seem to get any number displaying other than 1...

please help

thanks

Nikki

---

@Nikki

When saying page filter, do you mean a slicer visual? What is the "number figure", is that a card visual? If yes, What do you put in the card visual? Have you tried using any measure?

You question is not quite clear for me, could you please post some sample data and snapshot to show the exact purpose?