Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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?
Solved! Go to 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
To anwer this, we would need more information on the columns you want the summarize to happen.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
25 | |
12 | |
9 | |
9 | |
9 |
User | Count |
---|---|
19 | |
14 | |
14 | |
13 | |
13 |