topic Re: Disconnected Table in DAX Commands and Tips

Disconnected Table

Anonymous — Sat, 01 Apr 2023 18:38:51 GMT

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

Re: Disconnected Table

MohammadLoran25 — Sat, 01 Apr 2023 19:40:50 GMT

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

Re: Disconnected Table

Anonymous — Sun, 02 Apr 2023 06:09:36 GMT

I have tried but it is not working

Re: Disconnected Table

MohammadLoran25 — Sun, 02 Apr 2023 07:39:02 GMT

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

You put

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

in FILTER FUNCTION?

Re: Disconnected Table

Anonymous — Sun, 02 Apr 2023 15:27:16 GMT

Did you check my report?

Re: Disconnected Table

Anonymous — Mon, 03 Apr 2023 08:38:06 GMT

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

Re: Disconnected Table

MohammadLoran25 — Mon, 03 Apr 2023 15:34:50 GMT

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.