Forum Discussion

benmccarthy's avatar
benmccarthy
Frequent Visitor
1 year ago
Solved

DAX Measure not Totalling

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())
  • dharmendars007's avatar
    dharmendars007
    1 year ago

    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 

     

2 Replies

  • dharmendars007's avatar
    dharmendars007
    Memorable Member
    1 year ago

    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 

     

  • sjoerdvn's avatar
    sjoerdvn
    Solution Sage
    1 year ago

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