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

elcapitano's avatar
elcapitano
Regular Visitor
4 years ago

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