Forum Discussion
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...
You may use RELATED to add a calculated column instead. To check DAX query, take a look at Examine report elements with Performance Analyzer.
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.
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)Hi,
a) Thanks for your solution to my Request 2.👍
b) I need a solution for my Request 1 also.
THe problem and expected result is as below : (Refer Power BI File available at Link Rating File Folder 20200405 (File : MW_VendorRating.pbix).
You may use RELATED to add a calculated column instead. To check DAX query, take a look at Examine report elements with Performance Analyzer.
