DAX Measure not Totalling

[benmccarthy]

Hi,

I'm fairly new to PowerBi, I have created the following measure but when I try and sum up the values the Total is just 1 even though there are many occurences of 1 in the column.  If I just return Result it works correctly however when I put the IF statement around the measure I can't sum up the column and I need the IF statement!

Can someone please point me in the right direction?

Inefficient Range Count (FORM) =

VAR Result =

    CALCULATE(COUNT('WOLaborTime (PivotByFuntion)'[Efficiency Range (FORM)]),'WOLaborTime (PivotByFuntion)'[Efficiency Range (FORM)]="InEfficient")

RETURN

    If(Result>0,1,BLANK())

[sjoerdvn]

To anwer this, we would need more information on the columns you want the summarize to happen. 

[dharmendars007 · Accepted solution]

Hello @benmccarthy , 

You have use SUMX to get the row context inside your measure..please try the below measure.

Inefficient Range Count (FORM) =
SUMX(
'WOLaborTime (PivotByFuntion)',
IF(
'WOLaborTime (PivotByFuntion)'[Efficiency Range (FORM)] = "InEfficient",
1,0))

If you find this helpful , please mark it as solution and Your Kudos are much appreciated!

Thank You

Dharmendar S

LinkedIN