Disconnected Table

[sanju24]

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

[sanju24]

Did you check my report?

[MohammadLoran25]

Hi @sanju24 ,

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

[sanju24]

I have tried but it is not working

[MohammadLoran25]

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

You put 

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

in FILTER FUNCTION?

[sanju24]

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]

@sanju24 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.