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...
Need Help
seenai's avatar
seenai
Helper II
6 years ago

az38 

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

 

az38's avatar
az38
Community Champion
6 years ago

seenai 

I didn't dive deep in your calculation but try to place your statement into CALCULATE()

Calc_QPPM = CALCULATE((sum(T_MW_VR02[N.of Scraps (D)])+sum(T_MW_VR02[N.of Deviations (E)]))/sum(T_MW_VR02[Received Qty (F)])*1000000)

 

  • seenai's avatar
    seenai
    Helper II
    6 years ago

    az38 

    Hi

     

    I would like to explain the problem further as below.

    1st Measure Defined : Calc_QPPM (No problem till now)

    2nd Measure : Score_QPPM_Lookup  (This is based on measure Calc_QPPM).

    Now the problem is as below : (Updated Power BI File available at LinkRating File Folder 20200405 (File : MW_VendorRating.pbix).