Forum Discussion
Kavya123
5 years agoHelper III
Expression in DAX
Hi Everyone, We are converting report from Qlikview to Power BI. Please help me to write DAX expression for the same. I wrote the dax expression but I am not getting expected result. Dax expression...
Anonymous
5 years agoNot applicable
Hi Kavya123 ,
You can create the measeures as below:
Avg score of 1209 =
AVERAGEX (
FILTER (
ALLSELECTED ( 'PROFILERTABLENEWSUBMITTED Score' ),
'PROFILERTABLENEWSUBMITTED Score'[PDataPoint] = 1209
&& 'PROFILERTABLENEWSUBMITTED Score'[Answer_Flag] = 1
),
'PROFILERTABLENEWSUBMITTED Score'[NEWScore]
)Avg score of 1210 =
AVERAGEX (
FILTER (
ALLSELECTED ( 'PROFILERTABLENEWSUBMITTED Score' ),
'PROFILERTABLENEWSUBMITTED Score'[PDataPoint] = 1210
&& 'PROFILERTABLENEWSUBMITTED Score'[Answer_Flag] = 1
),
'PROFILERTABLENEWSUBMITTED Score'[NEWScore]
)Avg score of Total =
FLOOR (
AVERAGEX (
FILTER (
ALLSELECTED ( 'PROFILERTABLENEWSUBMITTED Score' ),
'PROFILERTABLENEWSUBMITTED Score'[Answer_Flag] = 1
),
'PROFILERTABLENEWSUBMITTED Score'[NEWScore]
),
1
)Measure =
CALCULATE (
DISTINCTCOUNT ( 'PROFILERTABLENEWSUBMITTED Score'[POrganization] ),
FILTER (
ALLSELECTED ( 'PROFILERTABLENEWSUBMITTED Score' ),
[Avg score of 1210] < [Avg score of total]
&& [Avg score of 1210] > [Avg score of 1209]
)
) + 0
If the above one is not working, please provide some sample data (exclude sensitive data) and your expected result with sample or screenshots. Thank you.
Best Regards