Struggling to get simple excel statements work

[Anonymous]

Hi all,

I'm brand new to power BI and have been told by a few people that power bi functionality mirrors excel.  At least from my beginner state, this doesn't appear to be the case. I'm hoping you can help me fix my if statement.  I have a strong suspicion from there i will need help writing a sumif / countif statement as well.

My if ( if([Weighted ABS Workload %]<=0.0349,1,0) ) statement was creating using a new measure (as opposed to new column).  The values are populating correctly at each row, however, for some reason my total isn't populating?  I should expecet to see the value of 10.

thanks,
Jason

[amitchandak]

@Anonymous ,

Try like sumx(summarize(Table,table[Date],"_sum", if([Weighted ABS Workload %]<=0.0349,1,0) ),[_sum])

[Greg_Deckler]

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

[Anonymous]

Thanks for the response Greg.

I'm struggling with the formula.  Please keep in mind this is coming from someone who is just beginning to learn python.

I've tried mirroring your formula as follows:

m_single = if([Weighted ABS Workload %] <= 0.0349, 1, 0)

m_total = 

var __table = summarize('Sheet1',

as you can see i get stuck when creating our variable __table.  My problem is my formula 'weighted abs workload %' is a measure as opposed to a column, and power BI doesn't appear to recognize measures in your formula?  The underlying formula in weighted abs workload % is ((actual - forecast) / forecast)

Thanks,
Jason

[Greg_Deckler · Accepted solution]

m_total = 

var __table = summarize('Sheet1',[Day],"Measure",[m_single])

RETURN

IF(HASONEVALUE('Sheet1'[Day]),[m_single],SUMX(__table,[Measure])