Forum Discussion

elcapitano's avatar
elcapitano
Regular Visitor
4 years ago
Solved

Aggregating fields but applying total at a specific dimension

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 co...
Need Help
  • mahoneypat's avatar
    mahoneypat
    4 years ago

    You can try an expression like this.

     

    Measure2 =
    VAR M1sumx =
    SUMX ( ALLSELECTED ( Table[Field] ), [Measure 1] )
    RETURN
    IF ( MIN ( Table[Field] ) = "A", M1sumx )

     

    Pat

vojtechsima's avatar
vojtechsima
Icon for Super User rankSuper User
4 years ago

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.