topic How to convert this Expression from QlikView Expression to Power BI DAX in Featured Members https://community.qlik.com/t5/Featured-Members/How-to-convert-this-Expression-from-QlikView-Expression-to-Power/m-p/2105026#M149 <P>Hi Team,</P> <P>I have an issue, This is my QlikView Expression :&nbsp;</P> <P><STRONG>Sum(aggr(rangesum( above( sum( [WeeklyChartData.% Actual]), 0,4)), WeeklyChartData.WeeklyChartDataKey)) /</STRONG></P> <P><STRONG>sum(aggr(rangesum( above( count( [WeeklyChartData.% Actual]), 0,4)), WeeklyChartData.WeeklyChartDataKey))</STRONG></P> <P><LI-WRAPPER></LI-WRAPPER></P> <P><STRONG>Now I want to convert into Power BI Dax.&nbsp;</STRONG></P> <P>How can I do the same?</P> <P>Regards,</P> <P>Qlik Member (AK)</P> <P>AK</P> Fri, 11 Aug 2023 20:11:44 GMT sona_sa 2023-08-11T20:11:44Z How to convert this Expression from QlikView Expression to Power BI DAX https://community.qlik.com/t5/Featured-Members/How-to-convert-this-Expression-from-QlikView-Expression-to-Power/m-p/2105026#M149 <P>Hi Team,</P> <P>I have an issue, This is my QlikView Expression :&nbsp;</P> <P><STRONG>Sum(aggr(rangesum( above( sum( [WeeklyChartData.% Actual]), 0,4)), WeeklyChartData.WeeklyChartDataKey)) /</STRONG></P> <P><STRONG>sum(aggr(rangesum( above( count( [WeeklyChartData.% Actual]), 0,4)), WeeklyChartData.WeeklyChartDataKey))</STRONG></P> <P><LI-WRAPPER></LI-WRAPPER></P> <P><STRONG>Now I want to convert into Power BI Dax.&nbsp;</STRONG></P> <P>How can I do the same?</P> <P>Regards,</P> <P>Qlik Member (AK)</P> <P>AK</P> Fri, 11 Aug 2023 20:11:44 GMT https://community.qlik.com/t5/Featured-Members/How-to-convert-this-Expression-from-QlikView-Expression-to-Power/m-p/2105026#M149 sona_sa 2023-08-11T20:11:44Z