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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
kkalyanrr
Helper V
Helper V

Passing Slicer Selection value in DAX Filter

Hello Team,

 

Can we pass slicer selection on to DAX query..

 

I'm using following DAX query 

 

SUMMARIZE( ABC , ABC[Region] , "Sum" , SUM(ABC[OrderValue]))

 

I'm using same query for few other summary selections based on other fields  , I was planning to have a slicer with options to select the summary output by region/category/type etc..

1 REPLY 1
hemantsingh
Helper V
Helper V

hi @kkalyanrr,

 

  If your tables are connected with relationships than I am sure slicer will work on the result of the formula you wrote. Just Give it a try once. Just in case if it doesn't work then kindly share your pbix file or some sample data with the tentative result you desire to achieve.

 

Regards,

Hemant

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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