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])...
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

        I have used the Month No. from Connected Calendar Table in the X asix of the visual and Total Calls Y-axis. And In Slicer the Month No. from disconnected table. Then performed a measure.

        Disconnected = CALCULATE([Total Calls],FILTER(ALL('Calendar Table'),MAX('Calendar Table'[Date])<=MAX('Master Table (2)'[Date])))
        But when using it The Slicer is not able to filter the visual. Can Please open the attached report link from above and see whts wrong in my report. 
        Thanks