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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.