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 1Measure 2A1017B5 C2

You can try an expression like this. Measure2 =VAR M1sumx =SUMX ( ALLSELECTED ( Table[Field] ), [Measure 1] )RETURNIF ( MIN ( Table[Field] ) = "A", M1sumx ) Pat

Aggregating fields but applying total at a specific dimension

Forum Discussion

Related content

degenerate dimensions

Applying SCD (slow changing dimensions) in OLTP or OLAP

RLS on multiple dimensions

concatenate string aggregating dimension

performing filter and aggregate function on dataset before applying TOPN