cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Re: Data Manipulation for Matrix Table

@MFelix  Thanks for your fast responses. Is this the method you are suggesting? I also created a duplicate measure that removes the sumx funtion by using the selected value within the Switch function as seen below.

 

SWITCH(
                  SELECTEDVALUE(MeasuresIdentication[ID]);
                  1; FORMAT(sumx([Measure1]);"0,0%");
                  2; FORMAT(sumx([Measure2]);"###.###);
                   ...;...;
                  99; FORMAT(sumx([Measure99]);"###.### $")
                 )
SWITCH(
                  SELECTEDVALUE(MeasuresIdentication[ID]);
                  1; FORMAT(sumx([Measure1]);"0,0%");
                  2; FORMAT(sumx([Measure2]);"###.###);
                   ...;...;
                  99; FORMAT(sumx([Measure99]);"###.### $")
                 )

VERSUS

SUMX(TABLE,
     SWITCH(TABLE[ID]),

 

Highlighted
Super User V
Super User V

Re: Data Manipulation for Matrix Table

Hi @jignaski18 ,

 

Yes that is the way I'm suggesting, as refered if you place a format function inside the SUMX the values will get error since you are trying to make a sum of text values.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog:

Power BI em Português





Highlighted
Helper I
Helper I

Re: Data Manipulation for Matrix Table

@MFelix This Solution worked. Measure Name in Column, Values in values, then conditional formatting for values (backround) selected value Conditional Formatting(measure).

 

Values = 
SWITCH( SELECTEDVALUE(Table[MeasureName]),
      1,Measure 1,            
      2,Measure 2,
      ...,...,..,
     etc. etc.)


Conditional Formatting=
               SWITCH(TRUE();
                  SELECTEDVALUE(Table[MeasureName]) = 1 && [Measure1] >0 ; "GOLD";
                  SELECTEDVALUE(Table[MeasureName]) = 1 && [Measure1] <0 ; "RED";
                   ...;...;
                  SELECTEDVALUE(Table[MeasureName]) = 99 && [Measure99] > 0 ; "GOLD";
                  SELECTEDVALUE(Table[MeasureName]) = 99 && [Measure99] < 0 ; "RED"
                 )

 

Highlighted
Super User V
Super User V

Re: Data Manipulation for Matrix Table

Glad I could assist.

 

Please mark the correct answer so that others can be helped.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog:

Power BI em Português





Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors