Handling multiple dates with one date picker in semantic model

Hi   

Your understanding is partly correct, but let me clarify precisely how this behaves in Power BI.

• If user selects Created Date → KPI shows count based on CreatedDate
• If user selects Modified Date → KPI switches to ModifiedDate

Works perfectly on:

• KPI cards
• Charts
• Tables

If nothing is selected on Data type slicer it will return the default count of values depending upon the active relationship. Just make a slight change to below variable (Assuming created date is your default active relationship)

VAR SelectedType = SELECTEDVALUE ('Date Type'[Type], "Created Date") 

If you want instead of showing the default active relationship count you want sum of both (modified and created date), then you can add another condition to the Dax that if data type is deselected or both are selected then show sum of both the variables, which we created in the Dax i shared

making these changes should fix your issue, Let me know what is you require any further assistance

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!