Forum Discussion

seenai's avatar
seenai
Helper II
6 years ago
Solved

Filter Issue and Lookup Table

Hi,

 

a) I found the measure not calculated properly when I apply YEAR Filter.

Both the TABLES with and without filters are shown in the Power BI File available at Link Rating File Folder 20200405 (File : MW_VendorRating.pbix).

I want to apply filter without affecting calculation.

 

b) In the same File, I have a measure Score_QPPM. It is made using IF function. I want to get the result using table Tbl_QPPM.

 

Please help me for these two points, if possible.

Need Help

7 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    seenai , I checked the file

    The information you have provided is not making the problem clear to me. Can you please explain with an example.

    Appreciate your Kudos.

      • az38's avatar
        az38
        Community Champion
        6 years ago

        Hi seenai 

        if i understand you correct you need smth like

        Score_QPPM new = 
var _QPPM = [Calc_QPPM]
var _Score = CALCULATE(FIRSTNONBLANK(Tbl_QPPM[QPPM Score],1), Tbl_QPPM[Lower bound] < _QPPM, Tbl_QPPM[Upper Bound]>=_QPPM)
RETURN
IF(ISBLANK(_Score), 25, _Score)