SELECTEDVALUE Dax with a Slicer to Dynamically Show Values in Power BI | Step by Step Tutorial

This is a very important tutorial for you to learn the basics of Power BI coding. Other than SELECTEDVALUE DAX, you will get to know,

- CALCULATE, MIN, MAX, and ISBLANK function,
and how to use variables in Power BI.

Sample code:

MIN_1 =

VAR Name_1 = SELECTEDVALUE(Sheet1[Name])

VAR Subject_1 = SELECTEDVALUE(Sheet1[Subject])

VAR MIN_R = CALCULATE(MIN(Sheet1[Marks]), Sheet1[Name] = Name_1, Sheet1[Subject] = Subject_1)

Return IF(ISBLANK(MIN_R), "Select Subject and Name", MIN_R)