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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
PowerBI_GER
Frequent Visitor

Dynamic DAX-Cal based on visual filter

Hello, i got a table with a lot of projects and activity dates. Therefore, i've created a DAX Calendar. My Problem: If i select a specific Project the filter does not fit my selection. I tried

 

dDAX-Cal =
VAR cMIN = CALCULATE(MIN('Table'[Date]), ALLSELECTED('Table'[Project]))
VAR cMAX = CALCULATE(MAX('Table'[Date]), ALLSELECTED('Table'[Project]))
RETURN
CALENDAR(cMIN,cMAX)
 
but it's always calculating the total MIN and total MAX, ignoring my selection regarding the project.
 
Link to my example file:
2 ACCEPTED SOLUTIONS
amitchandak
Super User
Super User

@PowerBI_GER , You can not supply slicer value to the table(Table creation). The table will be static

View solution in original post

HA! I knew it! Just wasn't sure due to some other Threads.

 

Thanks for your help! This way i kept searching and found a solution:

I set the filtering to 'Both' in my data model. Therefore, only the selected values are shown in the slicer.

 

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@PowerBI_GER , You can not supply slicer value to the table(Table creation). The table will be static

HA! I knew it! Just wasn't sure due to some other Threads.

 

Thanks for your help! This way i kept searching and found a solution:

I set the filtering to 'Both' in my data model. Therefore, only the selected values are shown in the slicer.

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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