Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Disconnected Table

I have used the formula like this but it not working . It is not filtering the visual only. CALCULATE([Total Calls],FILTER('Calendar Table', MAX('Calendar Table'[Date])<=MAX('Master Table (2)'[Date]))) for disconnected table . Like if I select Month No. 2 in slicer. The visual  should data show till 2nd Month. And not just 2nd Month. The Master Table(2) is disconnected table which is in slicer. Please Help someone. Below attached is the report link.

 

https://app.powerbi.com/groups/me/reports/6e6294a8-d629-45c6-827d-a74ad2feb507?ctid=e0793d39-0939-496d-b129-198edd916feb&pbi_source=linkShare 

6 Replies

  • MohammadLoran25's avatar
    MohammadLoran25
    Solution Sage
    3 years ago

    Hi Anonymous ,

    Try this:

    CALCULATE (
    [Total Calls],
    FILTER (
        ALL ( 'Calendar Table'[Date] ),
          'Calendar Table'[Date] <= MAX ( 'Master Table (2)'[Date] )
    )
)

     

     

    If this answer solves your problem, give it a thumbs up and mark it as an accepted solution so the others would find what they need easier.

    Regards,

    Loran

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      I have tried but it is not working

      • MohammadLoran25's avatar
        MohammadLoran25
        Solution Sage
        3 years ago

        I checked and it worked. What is wrong with it?

        You put 

        'Calendar Table'[Date] <= MAX ( 'Master Table (2)'[Date] )

        in FILTER FUNCTION?

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Did you check my report?