Forum Discussion

RalphBi's avatar
RalphBi
Regular Visitor
6 years ago

Measure Filtering

Hello,

I am fairly new to Power Bi and would appreciate any help with this 🙂

I currently want to filer information in a declared VAR with a measure value. 

Here is my current measure which is simply a quick measure to calculate the difference between the two months:

Delta =
VAR __BASELINE_VALUE = [Month2 SLA%]  *FILTER HERE BY MONTH 10*
VAR __VALUE_TO_COMPARE = [Month1 SLA%] *FILTER THIS VALUE BY MONTH 11*
RETURN
    IF(
        NOT ISBLANK(__VALUE_TO_COMPARE);
        DIVIDE(__VALUE_TO_COMPARE - __BASELINE_VALUE; __BASELINE_VALUE)
    )

Could this be done?

Thanks!

Need Help

3 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    6 years ago
    You can use calculate function,

    Calculate ( your measure, table[month]=11)

    Similar for other measure.
  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    RalphBi ,

     

    You may modify the measure using dax below:

    Delta =
VAR __BASELINE_VALUE =
    CALCULATE (
        MAX ( Table[Month2 SLA%] );
        FILTER ( Table; MONTH ( Table[Date] ) = 10 )
    )
VAR __VALUE_TO_COMPARE =
    CALCULATE (
        MAX ( Table[Month2 SLA%] );
        FILTER ( Table; MONTH ( Table[Date] ) = 11 )
    )
RETURN
    IF (
        NOT ISBLANK ( __VALUE_TO_COMPARE );
        DIVIDE ( __VALUE_TO_COMPARE - __BASELINE_VALUE; __BASELINE_VALUE )
    )

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • RalphBi's avatar
    RalphBi
    Regular Visitor
    6 years ago

    Thanks for the help guys, however the way I have it set up is I have a table with a Column named Closing Date from which [Month2 SLA%]  AND [Month1 SLA%] is fed from. 

     

    These two ([Month2 SLA%]) are a division measure where i get the Percentage SLA.

     

    My goal here would be being able to apply those filters like I can do visually two both values with different months for each. 

     

    By doing this I would like to achieve the difference between the two months.

     

    Month SLA Measures:

     

    Closing Date:

     

     

    I am really new to this, appreciate the help.