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 sim...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Community 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.