Forum Discussion

pandakillsalot's avatar
pandakillsalot
Icon for Helper II rankHelper II
8 years ago

How to create a calculate measure that can change dynamically with user selections on the report

Hi all,    I create a measure to calculate the a value, and use date as a selection.   What I wish to achieve is when the date in the slicer is less than Jan 31, 2018, the measurement value is CA...
Need Help
Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

ok, that helps.

 

And are [NumberPassesCorrect] and [Unique SN Count] both calculated measures over columns in that table?

 

I take it you use the StressProuduction[Date] column in your slicer?

 

 

[NumberPassesCorrect],[Unique SN count]

 

pandakillsalot's avatar
pandakillsalot
Icon for Helper II rankHelper II
8 years ago

And what I trying to get is an graph like this  

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    pandakillsalot,

    It seems that you want to create the following measure. Ensure that you create a measure rather than a calculated column.

     IF (
        MAX(StressProuduction[Date]) <= DATE(2018, 1, 31) , 
        CALCULATE(
            DIVIDE([NumberPassesCorrect],[Unique SN count],0)), 1 )



    Regards,
    Lydia

  • pandakillsalot's avatar
    pandakillsalot
    Icon for Helper II rankHelper II
    8 years ago

    Thank you for your reply. Yes, that's what I try to do. But here is the problem, when the max date is 4/1 which is later than 1/31, all FPY will be 1 instead of calculating from the formula, and this will screw data before  1/31. I wish I could get both data before 1/31 and data after 1/31 showed correctly on the screen.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    pandakillsalot,

    I am not very clear about your requirement. Do you want to show data before 1/31/ and after 1/31 even if you make selections in slicer? Could you please share a dummy PBIX file here and post expected result here?

    Regards,
    Lydia