Forum Discussion

theferret's avatar
theferret
Frequent Visitor
4 years ago

Really Dumb ALL question

I have a page with a filter on it where Datetable[Actual]="Yes". this limits the data to todays date   However I want ot count how many days are in the month chosen in totla so I wrote this expecti...
Need Help
PC2790's avatar
PC2790
Icon for Community Champion rankCommunity Champion
4 years ago

Hello theferret ,

 

Is the page filter that you are applying constitues of [Actual] Column? If that's a yes, so it should work.

If no, you will have to bring in the column name being used in your filter for this visual.

 

  • theferret's avatar
    theferret
    Frequent Visitor
    4 years ago

    It is a column in the Datetable titled [Actual] and 100% sure my page filter is using the same field

    • PC2790's avatar
      PC2790
      Icon for Community Champion rankCommunity Champion
      4 years ago

      I have tried to replicate your issue and it works fine for me.

      See below:

       

      [Actual] is a calculated column similar to what you described:

       

      Actual = 
if('DateTable'[Date] <= TODAY(),"Yes","No")

       

      Let me know if I am missing from this sample.

      • theferret's avatar
        theferret
        Frequent Visitor
        4 years ago

        Yup I have no idea why it doenst work as seems obvious?  i've moved the page filter otthe visuals as only solution. Bit wierd, but thnaks for looking at this