Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Greetings,
I'm trying to create a conditional measure that sums up all "stage 1" values only if "stage 3" has a value for the row item.
The data below is of sample source data, but when importing the data, I have unpivot the Stage 1 through to Stage 3 columns.
Item | Stage 1 | Stage 2 | Stage 3 |
1 | 100 | 100 | 100 |
2 | 100 | 100 | 100 |
3 | 100 | 100 | |
4 | 100 |
What sort of measure is best to calculate this?
Thanks in advance!
Solved! Go to Solution.
It would be easier if we could see the data as it exists in the tabular table. But if I understand your issue correctly the following psuedo code should work
= SUMX( table1 ,
IF( calculate(SUM(table1[Value]) , table1[Stage] = "Stage 3) > 0 ,
IF( table1[Stage] = "Stage 1", table1[Value] )
)
)
Hi @rgtanna ,
Please also try this one.
Measure 2 = VAR hasStage3Items = CALCULATETABLE ( VALUES ( Table1[Item] ), Table1[Stage] = "Stage 3" ) RETURN CALCULATE ( SUM ( Table1[Value] ), FILTER ( Table1, Table1[Item] IN hasStage3Items && Table1[Stage] = "Stage 1" ) )
Best Regards,
Hi @rgtanna ,
Please also try this one.
Measure 2 = VAR hasStage3Items = CALCULATETABLE ( VALUES ( Table1[Item] ), Table1[Stage] = "Stage 3" ) RETURN CALCULATE ( SUM ( Table1[Value] ), FILTER ( Table1, Table1[Item] IN hasStage3Items && Table1[Stage] = "Stage 1" ) )
Best Regards,
It would be easier if we could see the data as it exists in the tabular table. But if I understand your issue correctly the following psuedo code should work
= SUMX( table1 ,
IF( calculate(SUM(table1[Value]) , table1[Stage] = "Stage 3) > 0 ,
IF( table1[Stage] = "Stage 1", table1[Value] )
)
)
User | Count |
---|---|
77 | |
75 | |
46 | |
31 | |
28 |
User | Count |
---|---|
99 | |
93 | |
50 | |
49 | |
46 |