No video

Harvesting A Slicer Selection Within A DAX Measure For Dynamic Calculations

  Рет қаралды 29,539

Enterprise DNA

Enterprise DNA

Күн бұрын

Пікірлер: 38
@JonAyre-MBA
@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
@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
@ducloc632 Жыл бұрын
Exactly what I am looking for ! Thanks
@EnterpriseDNA
@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
@joelngige5776 3 жыл бұрын
Great video on how to carry out simulation analysis
@EnterpriseDNA
@EnterpriseDNA 3 жыл бұрын
Hi Joel Ngige, glad you appreciated the video. We are so grateful to have had such positive feedback.
@DavidRamos-mj8fy
@DavidRamos-mj8fy 11 ай бұрын
Just what I needed, thankyou
@pabeader1941
@pabeader1941 3 жыл бұрын
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
@EnterpriseDNA 3 жыл бұрын
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: kzfaq.info/love/y2rBgj4M1tzK-urTZ28zcA
@cozmicon
@cozmicon 3 жыл бұрын
If you use selectedvalue to pick up the slicer's value, probably also a good thing to set the slicer for single select
@SanchezOKelly
@SanchezOKelly 2 жыл бұрын
If you had a use case for multi select, what function would you use instead of selected value?
@williamarthur4801
@williamarthur4801 2 жыл бұрын
That was brilliant, and I could do it, which with DAX makes a nice change.
@EnterpriseDNA
@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
@Solomonha2 3 жыл бұрын
Great explanation and very useful!!!
@EnterpriseDNA
@EnterpriseDNA 3 жыл бұрын
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: kzfaq.info/love/y2rBgj4M1tzK-urTZ28zcA
@anaballesteros-sosa4007
@anaballesteros-sosa4007 3 жыл бұрын
Excellent. Thank you very much
@EnterpriseDNA
@EnterpriseDNA 3 жыл бұрын
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: kzfaq.info/love/y2rBgj4M1tzK-urTZ28zcA
@cptdeadeye2112
@cptdeadeye2112 3 жыл бұрын
Wonderful. Thank you!
@EnterpriseDNA
@EnterpriseDNA 3 жыл бұрын
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: kzfaq.info/love/y2rBgj4M1tzK-urTZ28zcA
@jayxpea
@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
@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 KZfaq 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
@jayxpea Жыл бұрын
@@EnterpriseDNA thank you I appreciate the response
@karennguyen7083
@karennguyen7083 Жыл бұрын
Thanks 😊
@EnterpriseDNA
@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!
@saadatnasibdar6656
@saadatnasibdar6656 2 жыл бұрын
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
@EnterpriseDNA 2 жыл бұрын
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 KZfaq 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 KZfaq 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/ kzfaq.info/love/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/ kzfaq.info/get/bejne/fqh2lpSWp7nKkmw.html
@alexrosen8762
@alexrosen8762 2 жыл бұрын
Super useful! Thanks :-)
@EnterpriseDNA
@EnterpriseDNA 2 жыл бұрын
Hi Alex, glad you appreciated the content. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Cheers!
@BenhurGiongo
@BenhurGiongo 3 жыл бұрын
Great!
@EnterpriseDNA
@EnterpriseDNA 3 жыл бұрын
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: kzfaq.info/love/y2rBgj4M1tzK-urTZ28zcA
@ashishmohan2956
@ashishmohan2956 3 жыл бұрын
Great SAM U r amazing
@EnterpriseDNA
@EnterpriseDNA 3 жыл бұрын
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: kzfaq.info/love/y2rBgj4M1tzK-urTZ28zcA
@pranaysharma8694
@pranaysharma8694 2 жыл бұрын
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
@EnterpriseDNA 2 жыл бұрын
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 KZfaq 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/ kzfaq.info/love/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/
@srenmlgaard2068
@srenmlgaard2068 2 жыл бұрын
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
@EnterpriseDNA 2 жыл бұрын
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 KZfaq 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 kzfaq.info/love/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/
@hemanadezhdank401
@hemanadezhdank401 2 жыл бұрын
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
@EnterpriseDNA 2 жыл бұрын
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 KZfaq 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/ kzfaq.info www.linkedin.com/groups/12004506/
Filtering calculation items in a slicer
11:24
SQLBI
Рет қаралды 15 М.
КТО ЛЮБИТ ГРИБЫ?? #shorts
00:24
Паша Осадчий
Рет қаралды 3,7 МЛН
SPILLED CHOCKY MILK PRANK ON BROTHER 😂 #shorts
00:12
Savage Vlogs
Рет қаралды 50 МЛН
Пройди игру и получи 5 чупа-чупсов (2024)
00:49
Екатерина Ковалева
Рет қаралды 4,3 МЛН
Change Measure using a Slicer
9:12
Goodly
Рет қаралды 60 М.
DAX Fridays #204: Slice by the results of a measure
10:59
Curbal
Рет қаралды 26 М.
A TWIST on dynamically filtering visuals by a slicer in Power BI
5:35
Using Power BI Field Parameters to add Measure Slicers to a Report
9:38
Using DAX to control a chart range in Power BI
25:23
SQLBI
Рет қаралды 16 М.