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