Harvesting A Slicer Selection Within A DAX Measure For Dynamic Calculations

[@JonAyre-MBA]

I have been trying to wrap my head around how I can do this, this video just solved what I thought was complex, into a digestible framework - thank you!

[@EnterpriseDNA]

Hi Alan, glad you found this video helpful! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!

[@ducloc632]

Exactly what I am looking for ! Thanks

[@EnterpriseDNA]

Hi Đức Lộc, glad you found this video helpful! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!

[@joelngige5776]

Great video on how to carry out simulation analysis

[@EnterpriseDNA]

Hi Joel Ngige, glad you appreciated the video. We are so grateful to have had such positive feedback.

[@DavidRamos-mj8fy]

Just what I needed, thankyou

[@pabeader1941]

I think that you have just unlocked a way for me to solve a problem I have been wrestling with for a while. I need to be able to have a slicer do something it wasn't designed to do. This harvesting technique could be the basis I needed. As far as the actual video though, of course, the actual quantity of sales will be impacted by the change in price. but so far I have seen no one that includes that in these types of videos. just because you increase the price doesn't mean you will make more money.

[@EnterpriseDNA]

Hi pa beader, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Here’s the link: kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA

[@williamarthur4801]

That was brilliant, and I could do it, which with DAX makes a nice change.

[@EnterpriseDNA]

Hi William, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!

[@Solomonha2]

Great explanation and very useful!!!

[@EnterpriseDNA]

Hi Tibebu, great that you found value in this video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Here’s the link: kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA

[@anaballesteros-sosa4007]

Excellent. Thank you very much

[@EnterpriseDNA]

Hi Ana Ballesteros-Sosa, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Here’s the link: kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA

[@jayxpea]

Great Video. I have two questions 1. Would the percentage change table be considered a disconnected table? 2. Is this the same as using number parameters function?

[@EnterpriseDNA]

Hi @oneeyeshutcreative, Below are the answers provided to your questions: 1) Yes, as showcased in the given video, percentage change table is a disconnected table and cannot be linked with any other tables in the data model i.e., with Fact and Dimension tables. 2) Yes, you can replace the table with the number parameters function and make it more dynamic. For further queries, you can also reach out to us at our Community Forum by providing a detailed description of your query along with relevant files for reference. Our members and team of Experts will be happy to help out! If you haven't yet, do subscribe to our KZbin channel and LinkedIn group to keep posted on the latest data skills and tools updates. Hoping you find this useful! Cheers, Enterprise DNA forum.enterprisedna.co/ www.youtube.com/@EnterpriseDNA www.linkedin.com/groups/12004506/

[@jayxpea]

@@EnterpriseDNA thank you I appreciate the response

[@cozmicon]

If you use selectedvalue to pick up the slicer's value, probably also a good thing to set the slicer for single select

[@SanchezOKelly]

If you had a use case for multi select, what function would you use instead of selected value?

[@cptdeadeye2112]

Wonderful. Thank you!

[@EnterpriseDNA]

Hi Razi Briga, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Here’s the link: kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA

[@karennguyen7083]

Thanks 😊

[@EnterpriseDNA]

Hi Karen, glad that this video is of help! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!

[@ashishmohan2956]

Great SAM U r amazing

[@EnterpriseDNA]

Hi ashish mohan, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Here’s the link: kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA

[@alexrosen8762]

Super useful! Thanks :-)

[@EnterpriseDNA]

Hi Alex, glad you appreciated the content. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Cheers!

[@srenmlgaard2068]

What if I have a table where the selected value is a version (fx P04_2022) and I want to compare the total sales for this version (measure select 1) with another version (measure select 2 fx P03_2022)?

[@EnterpriseDNA]

Hello Søren Mølgaard, Thank you for question. We appreciate your time. We need a detailed description on your question. It is a little difficult to tell and provide the results without looking at the data structure, model and working of the PBIX file. So we encourage you to please write back to us to our Community Forum by providing a thorough description of the problem that you're having along with the PBIX file you are using as reference, as well as the mock-up results that you're trying to achieve. Our members and/or experts team will be able to assist you in a better and efficient manner. I have provided the link to our forum below: forum.enterprisedna.co/ Please make sure that you're subscribed to our KZbin channel so you don't miss out any updates regarding Power BI. Along with it, you may also be interested to join our Power BI group on LinkedIn to receive latest updates. Links provided below for your reference. Happy Learning!!! Thanks and Warm Regards, Enterprise DNA kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/

[@hemanadezhdank401]

Is it possible to assign the selected value dynamically to pull in different column values. Say, YTD, MTD, QTD as the selected value in the slicer and they are the separate columns in time dimension. Then how is it possible to pick the YTD, MTD, QTD flags from time dimension table. Please suggest.

[@EnterpriseDNA]

Hello, Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post. Well, we're not able to understand the scenario or the query that you're trying to present here. And it's always a difficult task to provide the results or comments without looking at the data, it's structure and working of the PBIX file for the reference. And therefore we request you to please write back to us onto our Power BI Community Forum by providing the exact description of the problem that you're facing in along with the working or demo PBIX files for the reference where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the Community Forum provided for the reference purposes. Hoping you find this useful. Also, make sure that you're subscribed to our KZbin channel so that you don't miss out on any updates pertaining to the Power BI. You can also join our Power BI group on LinkedIn to receive latest updates on Power BI. Below are the links provided for the reference purposes. Cheers, Enterprise DNA forum.enterprisedna.co/ kzbin.info www.linkedin.com/groups/12004506/

[@BenhurGiongo]

Great!

[@EnterpriseDNA]

Hi Benhur Giongo, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Here’s the link: kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA

[@pranaysharma8694]

is there a way to make this work when the slicer format is a range. The selectedvalue function doesnt work when the slicer is a range of values

[@EnterpriseDNA]

Hello pranay, Thank you for posting your query onto our channel. No, there's no alternative here in this type of scenario. It's expected that user make one individual selection into the slicer at a time to see that particular scenario. How can one see or view the scenario's by converting the slicer into a range of values. For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well. Hoping you find this useful. Also, make sure that you're subscribed to our KZbin channel so that you don't miss out on any updates pertaining to the Power BI. You can also join our Power BI group on LinkedIn to receive latest updates on Power BI. Below are the links provided for the reference purposes. Cheers, Enterprise DNA forum.enterprisedna.co/ kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/

[@saadatnasibdar6656]

Hi, I am stuck with a challenge, where I need to show the Latest date of each ID(Each ID has multiple entries at different dates and times), but the catch is, there is a date slicer(Between option), so when we change the date in the slicer, Table should show the latest data based on the slicer. For example, the overall date range is from 01st April 2021 to 31st March 2022, so if the latest date for id 707 is 18th March, only this should display, but if the slicer is changed to 15th Apri1 2021 to 01st March 2022, then the latest date between this should display for ID 707 which may be 25th Feb 2022 Accordingly, with ID 707, we have multiple ids and all should display their latest data as per the selection

[@EnterpriseDNA]

Hi SAADAT NASIBDAR, Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it. Well, to achieve the results based on the scenario that you've specified, you can use the "MAX()" function. You measure should be something like this - Max Date Based On ID = MAX( 'Fact_Table_Name'[Date] ) We're providing few of the links of the articles from our blog posts as well as link of the video from our Enterprise DNA KZbin channel pertaining to this topic. For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well. Hoping you find this useful. Subscribe to our KZbin channel so that you don't miss out on any updates pertaining to the Power BI. You can also join our Power BI group on LinkedIn to receive latest updates on Power BI. Below are the links provided for the reference purposes. Cheers, Enterprise DNA forum.enterprisedna.co/ kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/ blog.enterprisedna.co/using-the-maxx-dax-function-in-power-bi-to-calculate-recent-values-in-your-data/ kzbin.info/www/bejne/fnOplGSbd7iZmJo