Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi folks,
I am hoping this is a simple question and its a bit of a funky problem to solve that I've not come across in Power BI. Basically if you imagine we have a dataset which produces Field column (with values A, B, C) and Measure 1 and we want to do something where a new measure (Measure 2) is an aggregate of the everything in Measure 1 but when we display it we only want it to sit at the field A and to ignore B and C
Is this sort of thing possible?
Field | Measure 1 | Measure 2 |
A | 10 | 17 |
B | 5 | |
C | 2 |
Solved! Go to Solution.
You can try an expression like this.
Measure2 =
VAR M1sumx =
SUMX ( ALLSELECTED ( Table[Field] ), [Measure 1] )
RETURN
IF ( MIN ( Table[Field] ) = "A", M1sumx )
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Thanks for the suggestions - both great. But I think I'll need to elaborate on the situtation a bit more as this piece works for a simple problem but I have something that's a bit more complicated so will create a follow up problem for it. Will create a PBIX file for it too
Hi, @elcapitano,
I am not sure it's the best approach to create a calculated column for this, I would probably just create a measure to specific visual, however, if you want to have a physical table like you showed, you can use something like this:
Measure 2 =
var summarizeEverything = sum('Table'[Measure 1])
var FieldCheck = "A"
var CheckCondition = if('Table'[Field] = FieldCheck, summarizeEverything)
return CheckCondition
If you want a more specific formula, please share the actual dataset.
You can try an expression like this.
Measure2 =
VAR M1sumx =
SUMX ( ALLSELECTED ( Table[Field] ), [Measure 1] )
RETURN
IF ( MIN ( Table[Field] ) = "A", M1sumx )
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
User | Count |
---|---|
80 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
98 | |
89 | |
82 | |
61 |