Forum Discussion

Snagalapur's avatar
Snagalapur
Icon for Helper IV rankHelper IV
1 year ago

Issue with slicer using calculated measure

Hi All,

 

Currently facing issue with slicer having calculated measures as mentioned below. I'm trying to filter table below based on slicer selction and slicer is not working please suggest.

 

Current month = MAX(‘Table’[current_period_ind])-1

Previous month = MAX(‘Table’ [current_period_ind])-2

 

Parameter = {

    ("Current month", NAMEOF('MEASURES_TABLE'[Current month]), 0),

    ("Previous month", NAMEOF('MEASURES_TABLE'[Previous month]), 1)

}

 

Matrix table/Dataset sample:

 

Need Help

1 Reply

  • grazitti_sapna's avatar
    grazitti_sapna
    Icon for Super User rankSuper User
    1 year ago

    Hi Snagalapur ,

     

    Have you added parameter column to the table as it's not showing in the screenshot? if not You should add it to the table in order to filter data with parameter slicer. 

     

    🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
    💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
    🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
    🔗 Curious to explore more? [Discover here].
    Let’s keep building smarter solutions together!