The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
Did you check my report?
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
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?
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.
@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.
User | Count |
---|---|
26 | |
10 | |
8 | |
6 | |
5 |
User | Count |
---|---|
33 | |
13 | |
12 | |
9 | |
7 |