Forum Discussion

Pallavi_m's avatar
Pallavi_m
Icon for Helper I rankHelper I
3 years ago
Solved

How to create a measure based on slicer selection

Hi,   I have a table that contains these values.. upto Oct 2040(monthyear) A slicer is created on monthyear column. -As per the slicer selection, I want to have a  measure that displays Oct 2022 ...
Need Help
Show and Tell
Tips and Tricks
  • danextian's avatar
    danextian
    3 years ago

    Hi Pallavi_m ,

     

    If you create a relationship between your Period and Fact tables, the measure will naturally show blank if the month  selected in  period doesn't exist yet in your fact table. You can create a Month Year calculated colum in Fact, say

    Month Year = FORMAT ( Fact[Date], "MMM YYYY" ) and then create relationship between this column and monthyear in Period.

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Pallavi_m ,

     

    Create a measure like below and add it to visual filter set value = 1.

    Measure = IF(SELECTEDVALUE('Table'[monthyear]) in VALUES('calendar'[monthyear])&&DATEVALUE(SELECTEDVALUE('Table'[monthyear]))<=EOMONTH(TODAY(),0),1,0)

     

danextian's avatar
danextian
Icon for Super User rankSuper User
3 years ago

Hi Pallavi_m ,

 

If you create a relationship between your Period and Fact tables, the measure will naturally show blank if the month  selected in  period doesn't exist yet in your fact table. You can create a Month Year calculated colum in Fact, say

Month Year = FORMAT ( Fact[Date], "MMM YYYY" ) and then create relationship between this column and monthyear in Period.