Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

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

6 REPLIES 6
Anonymous
Not applicable

Did you check my report?

MohammadLoran25
Solution Sage
Solution Sage

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
Not applicable

I have tried but it is not working

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

You put 

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

in FILTER FUNCTION?

Anonymous
Not applicable

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

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.