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])...
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
    • MohammadLoran25's avatar
      MohammadLoran25
      Solution Sage
      3 years ago

      Anonymous You have to Write

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

      in your measure and not the below:

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

       

      Your report is not accessible unfortunately.