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 Experts
how could i consolidate and re write the following three meaure as a varibale as they are taking some time to compuate the output answer...
measure 1.
Solved! Go to Solution.
@Anonymous ,
Maybe the measure should be like below:
Cumulative Complaint Rate =
VAR Cumulative_Complaints =
CALCULATE (
[TotalComplaintswithTrends],
FILTER (
ALLSELECTED ( PMS_FINANCIAL_PDS ),
PMS_FINANCIAL_PDS[Month Start] <= MAX ( PMS_FINANCIAL_PDS[Month Start] )
)
)
VAR Cumulative_Sales =
CALCULATE (
[TotalSalesTrend],
FILTER (
ALLSELECTED ( PMS_TM1_SALES_VOLUME ),
[Month Start] <= MAX ( PMS_FINANCIAL_PDS[Month Start] )
)
)
RETURN
IF (
DIVIDE ( Cumulative_Complaints, Cumulative_Sales, 0 ) <> 0,
DIVIDE ( Cumulative_Complaints, Cumulative_Sales, 0 )
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous ,
Maybe the measure should be like below:
Cumulative Complaint Rate =
VAR Cumulative_Complaints =
CALCULATE (
[TotalComplaintswithTrends],
FILTER (
ALLSELECTED ( PMS_FINANCIAL_PDS ),
PMS_FINANCIAL_PDS[Month Start] <= MAX ( PMS_FINANCIAL_PDS[Month Start] )
)
)
VAR Cumulative_Sales =
CALCULATE (
[TotalSalesTrend],
FILTER (
ALLSELECTED ( PMS_TM1_SALES_VOLUME ),
[Month Start] <= MAX ( PMS_FINANCIAL_PDS[Month Start] )
)
)
RETURN
IF (
DIVIDE ( Cumulative_Complaints, Cumulative_Sales, 0 ) <> 0,
DIVIDE ( Cumulative_Complaints, Cumulative_Sales, 0 )
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Try
//Option 1
averagex(summarize(FILTER(
ALLSELECTED(PMS_FINANCIAL_PDS),
[Month Start] <= MAX(PMS_FINANCIAL_PDS[Month Start])
),"_1",[TotalComplaintswithTrends],"_2",[TotalSalesTrend]),divide([_1],[_2]))
//Option 2
averagex(summarize(calculatetable(PMS_FINANCIAL_PDS,FILTER(
ALLSELECTED(PMS_FINANCIAL_PDS),
[Month Start] <= MAX(PMS_FINANCIAL_PDS[Month Start])
)),"_1",[TotalComplaintswithTrends],"_2",[TotalSalesTrend]),divide([_1],[_2]))
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 |
---|---|
111 | |
95 | |
77 | |
68 | |
54 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |