What is Selected Value in Power BI DAX Tutorial (26/50)

What is Selected value function in DAX,
How to Use SelectedValue Function in DAX,
How to select the values Slicer in DAX and use it as a filter in calculations,
Power bi dax tutorial with examples

#PowerBI #PowerBITutorials #SelectedValue

Complete Playlists

BI Developer - Complete Reference - Playlist
BI Architect - Complete Reference - Playlist

[mohitupadhayay]

This was an incredible example. Nags please keep adding a REAL TIME SCENARIO based Question and Answers too.

[uwqumlw]

Hi Nags, I have a question like, did we make relationship between Sales table and our newly created MonthList table and if no then how it is filtering sales amount with the newly created month filter...

[krishnaprasad-pcet]

its very much useful function sir.. i would like to clarify my doubt like.. if i have data from June till december and from january till may i dont have data. in a visual it has to show that Data not avalable for jan, Data not available for feb, so on for the first 5 months if we filter by month wise. could you please help me out in this.. Thank You very much in advance sir...

[ManaTelugodey]

Good explanation....if you put raw data also good for us..pls add rawdata also

[josejoel]

Please provide dataset in the description box.

[Rajashekar-usdw]

Please start Other Technologies Like ADF, Synapse etc....

[basavaj]

Sir without variable
Can we do this same scenario with switch and selected value function.
Please tell me.

[phillipk]

How do you hide those 3 options incl the three dot ellipsis when hovering a dashboard on some visuals like card, slicers, textbox, tables, etc. Are there any fancy or creative way of hiding those settings?

[dhinesh]

in dimdate table, whats the difference between month and monthnum column? if u have data, can u pls share

[phanindrayamsani]

Hi sir, the selected value is working good with only one selection in a filter but which function i can use for more than one value is selected in filter please let me know sir

[karthickom]

Sir when we have connected tables in our data, how to get the same result like while filtering particular month will return till that month.

[lakshmischannel]

SIr .. Summarize table use chesaru kada so no need to define any relation between DImdate and Sumarize table? How it is going to work in visualization

[aakashkrsinha]

Hi Sir,

I need a help as i am new to power bi, how can we do the same for week wise filter, i want to show last week performance basis on the week filtered, is it possible to do so??

[krutikapatil]

Hi sir, what if i have jan 2021 data and i want previous months like say nov 2020 and dec 2020, will this work in that case ?

[akshaynikam]

It's great content...
Sir please share reference data for the practice...

[venkataranganadh]

sir we created month list table right? why dont we refere monthlist or month number from that table, why you used dimdate table while filtering in calculate function

[piyushpathak]

Sir waiting for it sir if possible then try to upload more than one video plz.

[adityabodake]

how did it work without even completing calculate loop

[pvirendra]

Is there in power BI any Dax wherin we can find out our requiment

Requirment : i have entire 2023 sales data in power BI, in the comparison chart i want se current month vs last month sales, if i will select Dec month then chart should be Nov vs Dec only


Please let us know sir if you have any idea on this?

[dvinaykrishnavinaykrishn]

Sir maku sales table meru echina data lo ledu kada