Thanks so much for sharing this solution. I spent hours trying to figure it out in a situation with filters of different time periods on the same column, and it helped me to avoid duplicated sum.
This for me was the best and most important DAX Power Bi video I have seen. M management likes to look at selective items. This one did it, works great. Thank you
Oh my god, this is a lifesaver. I have a very odd dataset and up against a serous deadline, being able to get selected values from a slicer and then send variables to a dataset based upon those slicer values is incredible.
Thanks very much Ruth, this has been very useful. I love how your video is simple to understand and follow. Also thanks very much for your community PBIX files. Cant wait to check it out.
I just spent quite some time to figure out how to select multiple(!) options and not just one until your video pushed me finally in the right direction. Thank you a lot! :)
I have completed advanced dax course in udemy but they didn't give any basic explanation on allselected and selected value. But your 10 min video helped me understand basic intuition. Thanks a lot for your help.
Apparently you had already introduced us "IN" and "CONTAINSROWS" functions 79 DAX Fridays ago (#39), but I didn't remember even the existence of these functions until now. I guess it's time for a refresher... I'm afraid to find out what other useful functions I had forgotten but could have been perfect solutions for all these times that I was spending hours/days to come up with workarounds... but as they say, it's better late than never to learn (and re-learn... again...)! Thank you, Ruth!
Thank you so much for this .... Can you show us the same with date slicer... Where I have a period in the slicer like fromdate and to date kind of situation
Love your video Ruth, I am looking for some help. I am using date range slicer and on every selection I want to filter my page (filter chart and table data) for the selected date range and it should also include data for blank date values as well every time.
Hello mam, this video has the relative information of what I'm searching today, Just one question, can we display more than 2 values using the same DAX function? Thanks in advance!!
Thank you for your video. It was very clear. I have a question, please. If the user wants to filter on a visualization dimension (slicer) that concerns several columns. In advance, I wonder on which column I should add the dynamic filter condition based on the user’s choice. Example : Dimension de visualisation 2'[Categorie] -> Categorie contains the name of three different columns var selectcategory = SELECTEDVALUE('Dimension de visualisation 2'[Categorie]) return CALCULATE([Taux de complétude Linky], FILTER (NRJ_TRAFIC_PUISSANCE_MOIS, NRJ_TRAFIC_PUISSANCE_MOIS[selectcategory]) = "") thank you in advance for your return
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.
This is great but I was looking for a simpler way to filter data without a sum calculation. Is such a thing possible? For example I want to filter a list of months from current period to start of the year (YTD) using a slicer?
Hi This is the first time I see one of your video's. Thank you for taking the time and effort! Great solution! But... What do I need to change if I want this to work with a slicer that has tekst in it? Id like to show the selected strings in a card. (I have slicers on the first page of a report(synchronised for all other pages) and I'd like to show the selections on the pages with visuals)
Hi. this video is so helpful. I'm working on designing a dashboard in power bi. I want a user click on the slicer by name of project title. For example, the user click project A in the slicer. As a result, the graph will show that project A's progress for all months (Jan-Dec). Otherwise, if the user is not clicking the slicer, the graph remains blank. how I'm supposed to do? Thank you.
Thank you Ruth . i have question , i need to show report base on employee name or employee id so for that reason i create new table to show name/employeeid in drop down ( SelectTbl) and based on selected value i wrote new formula to create column newcolumn= if( SelectTbl[AnonymousSelected] = "name" , Employee[name] , Employee[ID] ) but it doesn't work . (seems formula doesnt work for column and it just work for measure ) so instead of adding new table , if new fake column added to Employee table and change formula to newcolumn= if( Employee[AnonymousSelected] = "name" , Employee[name] , Employee[ID] ) then it works! :( do you have any idea why powerbi is so lazy !?!(disappointed ! you can do whatever you want in tableau but ....)
This is super . However in this case we have only 1 measure or same style of measure (ony filter condition was changed). How about when we have different measures ?
Hi, thanks for your video. I have a question. I have 3 stages, Concept, Plan and Execution, for my project, I have put them in a filter in excel, now currently all activities are in the Concept stage, I want to show all the stages on the dashboard even though at present all activities are in the Concept stage, I want the dashboard to show all the other stages. I tried the option "Show all items with no data", but that doesn't work, any help please, thanks
Hi Ruth great because it is guiding me to the right direction. But I was wondering. What if I do not need to calculate, if I wanted filter the information from a table where selectedvalue >= column A and selectedvalue
The error is telling you that your Measure returns a table when only a value is allowed. Different solutions depending on what you are trying to do. Can you post in the power bi community, giving all the details? /Ruth
Hi I have a question , currently i am making a card where user will select a particular year and month and the value of a particular measure for that year and month will be shown in card please tell me how to put multiple condition inside selectedvalue from multiple column from filter?
I have 2 silters on 2 different columns, but when I use selectedvalue, Dax seems to get confused from which coumn to pull the data from... do you have a solution?
Hello, I'm new to your channel, but I really liked your way of explaining. Regarding this video, I have an exercise but with multiple periods, applying what you explain to us does not respect the filter I selected and adds everything up, can you help me? Thank you very much in advance
Hi Ruth, thank you very much for your videos. It has been quite tough for me to get what in SQL can be so simple to work in PowerBI. I was wondering if you could me with this specific issue: I have a Table which has Store_name,Country and I am now trying to calculate the % of Total Transactions for each Store but, has to be for any Countries selected on a Slicer. Let's say if I have Store_A/Country_1/50Transactions, Store_B/Country_1/50Transactions and Store_A/Country_2/200Transactions I want Store_A/Country_1=16.6% of Total Transactions,Store_B/Country_1=16.6% of Total Transactions and Store_A/Country_2=66.6% % of Total Transactions. I already have a simple DISTINCTCOUNT(Transactions) per row, but now I need the Total Transaction so that I can do the %. My Total Transaction = CALCULATE(DISTINCTCOUNT(Transaction),ALL(store_name)) is coming split by Country, so I getStore_A/Country_1=100Transactions, Store_B/Country_1=100Transactions, Store_A/Country_2=200Transactions instead of Store_A/Country_1=300Transactions, Store_B/Country_1=300Transactions, Store_A/Country_2=300Transactions which would allow me to then calculate the % of Total Transactions. I have played with various combinations of FILTER, ALL, ALLSELECTED but cannot seem to make it work. I feel like I am almost cracking PBI Grouping and Filtering but haven't made it yet... any help would be greatly appreciated. Gracias
Great video ,Hi I have a question in reverse , what if I multi select 3 months and do not want YTD for certain columns/Values (ie addition of 3 months)? For Example , I’m ok with YTD for revenue by Multiselecting but for some other values , I want position at end of month Example if I select jul aug sep , I want YTD for revenue which is fine and normal , but for some other columns I want values at end of August only ( not total of July aug sep) ?
Interestingly when you click A and B on your filter, it said 200 and 500 which shows only the inter-filter from your category table (which has chosen only category B). As a result it confuses me a little whether your slicer in effect works but I trust that it does.
I have one issue. I have 2 dates col in one table. I want to calculate MTD from date 1 and I want to use filter for date 2 column to get MTD for Date 1 values when filtered any specific month. How it could be possible?
Hi Curbal, If we don't select any value from slicer can we get aggregated value like (1500) without displaying category in the same table. If it's possible kindly let me know. Thanks :)
Hi Mam, Need your help. Using Slicers. i have one column consists of 20 different types of tasks. I want calculate task SLA's based on requirement. Say task 1 released date to task 5 closed date. another example like task 3 released date to task 20 closed date. based on my understandind like total four slicers will be there, two for From task list dropdown and another one will be to task list dropdown. and released date slicer and closed date slicer.
Excelente aporte muchisimas gracias. Me encuentro con un escenario similar pero no me da el resultado esperado, mas bien, no obtengo ningun resultado, solo error. Mi ejercicio es con un slicer de fechas (donde elijo un inicio y un fin) lo que necesito es, tanto de la fecha inicio como fin, identificar el año y el mes para posteriormente saber cual es la meta TOTAL de ese Mes&Año y no solo de los días que apliqué en el filtro
Thanks for this video, but this functionality is not working with the date slicer. I want to calculate date difference in days by comparing selected date of slicer. If anyone have solution then please let me know, and now as workaround i am using query parameter.
Thank you for your so useful videos ! I used your tip in this video on Power BI, it works perfectly ! But... when I write the same dax measure in Excel / Power pivot, I get a syntax error message about the "in" :-( Have you an idea why I can't use it in Power Pivot ?
Nice! I kinda have a similar scenario, could you help me out here? I have a Table1 with two columns: Employee Name and their Joining Date and Table2 with just dates for a user to select from a dropdown. Can I use the selected date from the user and compare it with the Joining dates in Table1 to create a flag (to check if the employee joined in the selected month or before the selected month) ?
I have an issue. I wanted to calculate the lowest value in a column for each year. Using the min implicit function I am able to get the minimum value. But when I put this on an animated bar chart, it displays all the minimum values of that particular year. Whereas, I wanted the lowest value per year to be displayed. Here is the code in DAX which I tried but the result is the same: Lowest per year = MINX (FILTER ( Dates, Dates[Year]), MIN('Score board'[Lowest Total.Score] ) )
Hi Madam it was beautiful video. Would like to ask if have item with multiple cost price i am getting the sum of cost price instead of showing all the cost price individually kindly suggets please with a video if you have made any on this topic
Every single time management asks for some update that seems will take me hours of work, I come to your channel and find a soluiton that makes it minutes.
Hi Ruth, Thanks for making such beautiful and informative videos. I was recently working on a requirement and I need selected values in a date slicer (From date - To Date) Can you please tell me how can I do that? Rishabh
Great Ruth, finally someone who can explain clearly PowerBI !
🥳🥳
/Ruth
Thanks so much for sharing this solution. I spent hours trying to figure it out in a situation with filters of different time periods on the same column, and it helped me to avoid duplicated sum.
This for me was the best and most important DAX Power Bi video I have seen. M management likes to look at selective items. This one did it, works great. Thank you
Glad to hear!!
In my opinion the best part of the video was the explanation of the IN operator. Thanks for sharing.
Thanks Andre! It was a great example to explain it :)
/Ruth
Oh my god, this is a lifesaver. I have a very odd dataset and up against a serous deadline, being able to get selected values from a slicer and then send variables to a dataset based upon those slicer values is incredible.
Good luck with your project !!
Thanks very much Ruth, this has been very useful. I love how your video is simple to understand and follow. Also thanks very much for your community PBIX files. Cant wait to check it out.
Thanks to you Pradeep for the feedback!
/Ruth
YOU'VE JUST SAVED MY WORKDDAY MAM, THANK YOU SO MUCH! Take my like and my subscription!
Welcome!! 🎉🎉
Wow this solved my problem so quickly, spinning my wheels on different forums until I found this. Thank you!!!
I love your videos. It's always so inspiring, it just gave me an idea to solve something that was considered unsolvable.
Music to my ears!!
Ruth u have always the answers for all my Dax problems, hehe, thanks a lot a gain. You r the greatest teacher ever!
We are probably working the same paths ;)
/Ruth
Thanks a lot - I was able to solve many of my problems/questions with you videos. Really appreciate the time you spend sharing!
And your feedback makes it all worth it, thanks!
I just spent quite some time to figure out how to select multiple(!) options and not just one until your video pushed me finally in the right direction. Thank you a lot! :)
Congrats, i completely understand the feeling :)
This helped me a lot. Thank you so much. IN Function is magical!
Great!! I was searching for a week trying to solve this!! You are amazing! Thank you so much!!
Yey!! Glad it helped!
Thank you so much for all of your videos. You have helped me so many times. I appreciate you very much.
And Thanks for supporting me and my work, appreciate it too :)
Thanks Ruth, you're the best! greetings from Brazil
Obrigada 😄
Thanks you!! I was needing this solution, and after a whole day of working I got it becouse of you :)
Thank you Ruth. I never knew about "IN". I used it to count the number of slicer items selected.
Yes, that is a great use case for IN, well done!
4 years old video, solved my problem today!!! THANKS
Fantastic and well done!! 👏👏
Ruth, thanks a lot! You saved my day!
OMG I was trying to figure this our for hours! Thank you!!!
Thank you for the great explanation. I have a question, Why didn't we put values instead of selectedvalue ?hank you
I was cracking my head, all I had to do was changing = to "IN". You rock!
🥳🥳
Outstanding! Thanks Ruth!
I have completed advanced dax course in udemy but they didn't give any basic explanation on allselected and selected value. But your 10 min video helped me understand basic intuition. Thanks a lot for your help.
Awesome. Thanks a lot, this is exectly the solution I wanted googling how to get list of selected values from a slicer)
That’s amazing! You saved my 2 months of PBI efforts to get rejected just because of I couldn’t figure out how to do this requirement applied over.
Haha the end there where you got turned around, welcome to half of my day at work! I love your videos so much, you've taught me so so so much.
😂😂😂 Mine too!!
/Ruth
Thank you for making our lives easy :)
At your service ;)
This is great. Thanks so much. Just one question: what do we do with the Category card that returns blank when multiple values are selected?
Apparently you had already introduced us "IN" and "CONTAINSROWS" functions 79 DAX Fridays ago (#39), but I didn't remember even the existence of these functions until now. I guess it's time for a refresher... I'm afraid to find out what other useful functions I had forgotten but could have been perfect solutions for all these times that I was spending hours/days to come up with workarounds... but as they say, it's better late than never to learn (and re-learn... again...)! Thank you, Ruth!
Believe me DAX Fridays is a function refresher for me too and I check my old videos all the time!!
Weird to learn from a past self 😂😂😂
/Ruth
@@CurbalEN whoa, don't mess with the Space-Time Continuum, Ruth! That's some dangerous stuff! lol
😂😂😂 I knoooowww!
/Ruth
simple but very effective!!! Many thanks Ruth 👍!!!!!
Yey!!! The pleasure is all mine :)
/Ruth
Thank you so much for this .... Can you show us the same with date slicer... Where I have a period in the slicer like fromdate and to date kind of situation
Love your video Ruth, I am looking for some help. I am using date range slicer and on every selection I want to filter my page (filter chart and table data) for the selected date range and it should also include data for blank date values as well every time.
Thank you So much, you solved my 72 hours head scratching issue.
Your session is full of informative .....please keep it up your work
Will do thanks!
Thank you soooo MUCH! I spent hours trying to figure this out!
🥳🥳🥳🥳
Awesome trick indeed
Thanks for sharing your thoughts!
Very ellegant solution. I was really stuck on that issue.
Awesome! Exactly what I was looking for!
Thank you!
🥳
/Ruth
you videos are great! have a question though? What if I have 3 slicers? Can I still use this?
What if I wanted to select A, and always have B show as the constant comparison value as well as A or whatever else is selected? How could I do that?
Great video Ruth - wondering, how can the card show the multiple values selected i.e. A, B, C rather than Blank?
A card can only show one value. To show more you can use a table instead :)
/Ruth
Hello mam, this video has the relative information of what I'm searching today, Just one question, can we display more than 2 values using the same DAX function?
Thanks in advance!!
was struggling with a calc and this helped bridge the gap :) wonderful!
Yey!!
Thank you for your video. It was very clear.
I have a question, please. If the user wants to filter on a visualization dimension (slicer) that concerns several columns.
In advance, I wonder on which column I should add the dynamic filter condition based on the user’s choice.
Example : Dimension de visualisation 2'[Categorie] -> Categorie contains the name of three different columns
var selectcategory = SELECTEDVALUE('Dimension de visualisation 2'[Categorie])
return
CALCULATE([Taux de complétude Linky],
FILTER (NRJ_TRAFIC_PUISSANCE_MOIS, NRJ_TRAFIC_PUISSANCE_MOIS[selectcategory]) = "")
thank you in advance for your return
Nice Video but what to do if I want the sum of total amount for category B even if category A and B are selected. Thanks in advance for your response.
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.
This is great but I was looking for a simpler way to filter data without a sum calculation. Is such a thing possible?
For example I want to filter a list of months from current period to start of the year (YTD) using a slicer?
What if we can take out the unique categories from the orders table to make the slicer and filter the table with that slicer?
Hi This is the first time I see one of your video's. Thank you for taking the time and effort! Great solution!
But...
What do I need to change if I want this to work with a slicer that has tekst in it? Id like to show the selected strings in a card.
(I have slicers on the first page of a report(synchronised for all other pages) and I'd like to show the selections on the pages with visuals)
Hi. this video is so helpful.
I'm working on designing a dashboard in power bi. I want a user click on the slicer by name of project title.
For example, the user click project A in the slicer. As a result, the graph will show that project A's progress for all months (Jan-Dec). Otherwise, if the user is not clicking the slicer, the graph remains blank. how I'm supposed to do?
Thank you.
Thank you Ruth . i have question , i need to show report base on employee name or employee id
so for that reason i create new table to show name/employeeid in drop down ( SelectTbl)
and based on selected value i wrote new formula to create column
newcolumn= if( SelectTbl[AnonymousSelected] = "name" , Employee[name] , Employee[ID] )
but it doesn't work . (seems formula doesnt work for column and it just work for measure )
so instead of adding new table , if new fake column added to Employee table and change formula to
newcolumn= if( Employee[AnonymousSelected] = "name" , Employee[name] , Employee[ID] )
then it works! :(
do you have any idea why powerbi is so lazy !?!(disappointed ! you can do whatever you want in tableau but ....)
This is super . However in this case we have only 1 measure or same style of measure (ony filter condition was changed). How about when we have different measures ?
Love You!!!! from Argentina!
Thanks a lot for such a wonderful video🙏🏻🙏🏻
Hi, thanks for your video. I have a question. I have 3 stages, Concept, Plan and Execution, for my project, I have put them in a filter in excel, now currently all activities are in the Concept stage, I want to show all the stages on the dashboard even though at present all activities are in the Concept stage, I want the dashboard to show all the other stages. I tried the option "Show all items with no data", but that doesn't work, any help please, thanks
Hi Ruth great because it is guiding me to the right direction. But I was wondering. What if I do not need to calculate, if I wanted filter the information from a table where selectedvalue >= column A and selectedvalue
The error is telling you that your Measure returns a table when only a value is allowed.
Different solutions depending on what you are trying to do. Can you post in the power bi community, giving all the details?
/Ruth
I want to auto fill/ select the value of a multi-select slicer based on another integrated slicer. Is that possible?
Hi I have a question , currently i am making a card where user will select a particular year and month and the value of a particular measure for that year and month will be shown in card please tell me how to put multiple condition inside selectedvalue from multiple column from filter?
You saved my bacon once again, thank you!
Big Thanks for the video and explanation, you are awesome. it saved my life. Subscribed :)
Welcome!
This was of a great help for me. Thank you a lot!
🥳🥳
Awesome, great knowledge, exactly looking for that 👍
I have 2 silters on 2 different columns, but when I use selectedvalue, Dax seems to get confused from which coumn to pull the data from... do you have a solution?
Hello, I'm new to your channel, but I really liked your way of explaining. Regarding this video, I have an exercise but with multiple periods, applying what you explain to us does not respect the filter I selected and adds everything up, can you help me? Thank you very much in advance
Hey does this solution still work?
This is great, but is there a way to do this with the slicer column being in the same table as the measure? Cause this is kinda silly to be honest
thanks Ruth ..it is well explained and helps on my work .
Awesome to hear!
/Ruth
Just what I needed, THANK YOU
Hi Ruth, thank you very much for your videos. It has been quite tough for me to get what in SQL can be so simple to work in PowerBI. I was wondering if you could me with this specific issue:
I have a Table which has Store_name,Country and I am now trying to calculate the % of Total Transactions for each Store but, has to be for any Countries selected on a Slicer. Let's say if I have Store_A/Country_1/50Transactions, Store_B/Country_1/50Transactions and Store_A/Country_2/200Transactions I want Store_A/Country_1=16.6% of Total Transactions,Store_B/Country_1=16.6% of Total Transactions and Store_A/Country_2=66.6% % of Total Transactions.
I already have a simple DISTINCTCOUNT(Transactions) per row, but now I need the Total Transaction so that I can do the %. My Total Transaction =
CALCULATE(DISTINCTCOUNT(Transaction),ALL(store_name)) is coming split by Country, so I getStore_A/Country_1=100Transactions, Store_B/Country_1=100Transactions, Store_A/Country_2=200Transactions instead of Store_A/Country_1=300Transactions, Store_B/Country_1=300Transactions, Store_A/Country_2=300Transactions which would allow me to then calculate the % of Total Transactions. I have played with various combinations of FILTER, ALL, ALLSELECTED but cannot seem to make it work. I feel like I am almost cracking PBI Grouping and Filtering but haven't made it yet... any help would be greatly appreciated. Gracias
Hi!
Would you mind to ask in the power bi community? Thanks!
/Ruth
Hi Ruth, I likes your videos on DAX...
Could you pls make a video on Selectedmeasure(), IsSelectedmeasure()
Great video ,Hi I have a question in reverse , what if I multi select 3 months and do not want YTD for certain columns/Values (ie addition of 3 months)? For Example , I’m ok with YTD for revenue by Multiselecting but for some other values , I want position at end of month
Example if I select jul aug sep , I want YTD for revenue which is fine and normal , but for some other columns I want values at end of August only ( not total of July aug sep) ?
Thanks a million! This has been greatly helpful!
Yey!!
Interestingly when you click A and B on your filter, it said 200 and 500 which shows only the inter-filter from your category table (which has chosen only category B).
As a result it confuses me a little whether your slicer in effect works but I trust that it does.
I have one issue. I have 2 dates col in one table. I want to calculate MTD from date 1 and I want to use filter for date 2 column to get MTD for Date 1 values when filtered any specific month. How it could be possible?
Such a great trick. Thanks a lot!
Yey!!
You save my life ! I love you ; )
Hi Curbal,
If we don't select any value from slicer can we get aggregated value like (1500) without displaying category in the same table. If it's possible kindly let me know. Thanks :)
Hi Mam, Need your help. Using Slicers. i have one column consists of 20 different types of tasks. I want calculate task SLA's based on requirement. Say task 1 released date to task 5 closed date. another example like task 3 released date to task 20 closed date. based on my understandind like total four slicers will be there, two for From task list dropdown and another one will be to task list dropdown. and released date slicer and closed date slicer.
I was struggling on something simple for days and looks like a possible solution here.
Thanks a lot! this is very clear and helpful
Excelente aporte muchisimas gracias.
Me encuentro con un escenario similar pero no me da el resultado esperado, mas bien, no obtengo ningun resultado, solo error.
Mi ejercicio es con un slicer de fechas (donde elijo un inicio y un fin) lo que necesito es, tanto de la fecha inicio como fin, identificar el año y el mes para posteriormente saber cual es la meta TOTAL de ese Mes&Año y no solo de los días que apliqué en el filtro
Hola! La comunidad de power bi es el sitio perfecto para este tipo de preguntas, pruébalo!
/Ruth
Thanks for this video, but this functionality is not working with the date slicer.
I want to calculate date difference in days by comparing selected date of slicer.
If anyone have solution then please let me know, and now as workaround i am using query parameter.
Thank you for your so useful videos ! I used your tip in this video on Power BI, it works perfectly ! But... when I write the same dax measure in Excel / Power pivot, I get a syntax error message about the "in" :-( Have you an idea why I can't use it in Power Pivot ?
Hi, how do you show default value when there is no selection?
Nice! I kinda have a similar scenario, could you help me out here? I have a Table1 with two columns: Employee Name and their Joining Date and Table2 with just dates for a user to select from a dropdown. Can I use the selected date from the user and compare it with the Joining dates in Table1 to create a flag (to check if the employee joined in the selected month or before the selected month) ?
just waooo.. This is what I was looking for exactly!!
Fab!!
Excelente, Ruth. Muy agradecido por tu aporte. Saludos.
Saludos y buen finde!
/Ruth
You are an Angel
I have an issue. I wanted to calculate the lowest value in a column for each year. Using the min implicit function I am able to get the minimum value. But when I put this on an animated bar chart, it displays all the minimum values of that particular year. Whereas, I wanted the lowest value per year to be displayed. Here is the code in DAX which I tried but the result is the same:
Lowest per year = MINX
(FILTER
(
Dates,
Dates[Year]),
MIN('Score board'[Lowest Total.Score]
)
)
Hi Madam it was beautiful video. Would like to ask if have item with multiple cost price i am getting the sum of cost price instead of showing all the cost price individually
kindly suggets please with a video if you have made any on this topic
Very good and very helpful, love it.
Excelente tip Ruth, muchas gracias!!!
Un placer y buen finde!
/Ruth
If I don't want select a,b,c , table measure should blank. Can any one help on it
You are my hero
Thanks, Thanks!!!!! You are the best! :D
You too 🎉🎉
I want to use selected date start and end date but it returns only data inceluded dates.
Magical In. Thanks for sharing
Neat function :)
/Ruth
Every single time management asks for some update that seems will take me hours of work, I come to your channel and find a soluiton that makes it minutes.
😊😊 Well done!
Hi Ruth,
Thanks for making such beautiful and informative videos. I was recently working on a requirement and I need selected values in a date slicer (From date - To Date)
Can you please tell me how can I do that?
Rishabh
ToDate= CALCULATE(
MAX(DimDate[FullDateAlternateKey]),
ALLSELECTED(DimDate)
)
Use MIN for the FromDate :)