Measure Filtering

[RalphBi]

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!

[RalphBi]

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. 

[v-yuta-msft]

@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.

[parry2k]

You can use calculate function,

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

Similar for other measure.