Forum Discussion

MP_123's avatar
MP_123
Microsoft Employee
9 years ago
Solved

Filter with calculated measures

hi, i know that calculated measures is changing regard it's context. i'm using a 'Text' type calculated measure to filter another calculated measure. since it's value is not stable, filter with ca...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    MP_123

    how can i filter with dynamically filter?

    Have you tried the VAR function that I mentioned in your previous thread? In this scenario, the formula should like below.

    = 
    VAR m = Measures
    RETURN
    CALCULATE ( SUM ( 'x' ), FILTER ( 'y', column = m ) )

    If the result is still not right, could you post your table structure and the measures you use, and some sample data in your case?:smileyhappy:

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

MP_123

how can i filter with dynamically filter?

Have you tried the VAR function that I mentioned in your previous thread? In this scenario, the formula should like below.

= 
VAR m = Measures
RETURN
CALCULATE ( SUM ( 'x' ), FILTER ( 'y', column = m ) )

If the result is still not right, could you post your table structure and the measures you use, and some sample data in your case?:smileyhappy:

 

Regards

MS_1234's avatar
MS_1234
New Member
4 years ago

Hi, 

 

I have a table with 3 Columns
Report Name | Manager | Status

Status contains Values: Pass, Fail, NA

 

I want to calculate % Pass for each manager. NA should be calculated in %of calculation.
I created one measure to calculate Total of Pass and Fail. and tried creating another measure for only "Pass". But its same % value for each manager. 

 

I am showing this data in Matrix. Please guide. Thanks!