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

Hi v-huizhn-msft

 

Thank you very much. 

 

I have made your measures, but the only thing I cannot get working is to get the "result" to react with slicer selections. 

 

My slicer is from a separate date table with a relationship to the table with the data. Anything I am missing?

 

Thank you:)

 

//Rvn

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

Hi Rvn86,

For my example, the slicer is also from a separate table. Please check if slicer effect your report by clicking "Edit interactions" under Fomant on home page. Please see the following screenshot, you should select the funnel button rether than the circle button.



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