Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have Created a measure Calc_QPPM.
Now I want to create another measure using Calc_QPPM, as below.
Its not showing properly.
Request your help.
Note :
Solved! Go to Solution.
@seenai Try like this
maxx(summarize(T_MW_VR02, Month[Month Name], vendor[ID],, vendor[name],"_Mes",[Score_QPPM ]),[_Mes])
Hop KPI QPPM is same as Score_QPPM.
Share calculation of Calc_QPPM
Hi, @amitchandak
a) Yes. KPI QPPM is same as Score_QPPM.
KPI QPPM : Excel Value
Score_QPPM : Power BI Calculation. It is needed for consolidation purpose.
b) Formula for Calc_QPPM is as below :
Calc_QPPM = (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 Try like this
maxx(summarize(T_MW_VR02, Month[Month Name], vendor[ID],, vendor[name],"_Mes",[Score_QPPM ]),[_Mes])
Hi
I have reverified my measures and data.
There is Month_Year Table (Calender), for use as common filter between databases.
The relationship is as shown below.
The measure is working OK, if don't apply any filter.
It is not Ok, only if I put Year Filter. Help me, if any.
Hi @seenai ,
I tested your formula, no problem, I do n’t know how you display your measure, you cannot display the measure alone, you need to display it with other columns, otherwise the result returned by the measure is aggregated.
Calc_QPPM = ( SUM('Sales 2015'[Sale 2013])+SUM('Sales 2015'[Sale 2014]) ) /SUM('Sales 2015'[Sale 2015])*1000000
Score_QPPM =
IF(
[Calc_QPPM] <= 50000000,
25,
IF(
[Calc_QPPM] <= 50000,
22,
IF(
[Calc_QPPM] <= 1000000,
20,
15
)
)
)
If the problem is not resolved, please describe how you intend to display the measure.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |