Forum Discussion

Rvn86's avatar
Rvn86
Helper I
9 years ago
Solved

Count date previous date rows based on slicer selection

Hi,   I want to count the number of date rows based on a date chosen from a slicer.    I have the following columns:   Startdate End date   I want to count every date with a start date if th...
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Hi Rvn86,

    You can try the following steps to check.

    1. Create a new table including the slicer field, and get the selected value in new table. More details, please review this thread. 

    2. Create a card visual to display your measure value, so you can debug it step by step.

    Best Regards,
    Angelia

Rvn86's avatar
Rvn86
Helper I
9 years ago

Thanks again, v-huizhn-msft :-)

 

Yes, I know about this option, but it is not the interaction itself. When I choose a date, the formula does not consider the chosen date. It only counts when I choose days with data in it. 

 

I think it has to do with the date table and the relation between my data and the date table. 

 

I will work on this later this week, and follow up with more questions if I do not solve it.

 

Thank you very much for your willingness to reply. I really appreciate it. 

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi Rvn86,

You can try the following steps to check.

1. Create a new table including the slicer field, and get the selected value in new table. More details, please review this thread. 

2. Create a card visual to display your measure value, so you can debug it step by step.

Best Regards,
Angelia