Power BI Dax Conversion of Sumx in Paginated Reports

[Vishruti]

Hello,

I have following measure in Power BI Desktop report:

% Project Completed =

Divide ( Sumx( Table, (Table[TaskDuration]*(Table[TaskPercentCompleted]/100))), sum(Table[TaskDuration]), blank()) + 0

When I add this measure in Paginated report, it is not showing the right values.

Can you help me write a custom formula that works in paginated report from the above formula?

The problem I am facing is that there is no Sumx function in paginated report. Also, I need it to show 0% in case of blank. 

[Anonymous]

Hii @Vishruti ,

try this

= IIF(SUM(Table[TaskDuration]) = 0, 0, SUM(Table[TaskDuration]*Table[TaskPercentCompleted])/100)/SUM(Table[TaskDuration])

[Anonymous · Accepted solution]

hi @Vishruti ,

try below condition


=IIF(Sum(Fields!TaskDuration.Value) = 0, 0,
(Sum(Fields!TaskDuration.Value * (Fields!TaskPercentCompleted.Value / 100))) / Sum(Fields!TaskDuration.Value))

[Vishruti]

Hello @Anonymous 

Somehow this formula is not working