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 expecting it to ignore the page filter and count 31 days in July.  However it doenst work and still producing 27 as its the 27th today.  I have no idea why this doesn't work as counldnt be any simpler? 

 

 

Total Days in Period = CALCULATE(COUNTROWS(DateTable),ALL(DateTable[Actual]))

 

 

Any clues as seems ot be text book way to do this? Sadly modle is enormous so cant post it.   If I click off the page filter it calcuates 31 so sure notihng lese is filtering as well

 

Thanks

Mike

 

Need Help

4 Replies

  • 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.