Forum Discussion

BIswajit_Das's avatar
BIswajit_Das
Icon for Impactful Individual rankImpactful Individual
2 years ago
Solved

POWER BI MATRIX

Hello  If there a table like code p_no` name num area sa 1 a 1 a sa 1 b 2 b sa 1 c 3 a sa 1 d 4 a sa 1 e 5 b sa 1 f 6 a sa 1 g 7 b sa 1 ...
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi BIswajit_Das ,

    Sorry for being late, please change the DAX into this:

    Measure = var _tab=SUMMARIZE(ALLSELECTED('Sheet18'[RES]),'Sheet18'[RES], "@sumvalue",CALCULATE(COUNT(Sheet18[NUM])))
var _max= maxx( _tab,[@sumvalue])
var _area=SELECTEDVALUE('Sheet18'[RES])
return  SWITCH(TRUE(),COUNT('Sheet18'[NUM])=_max&&_area="a","Blue", COUNT('Sheet18'[NUM])=_max&&_area= "b","Black",COUNT(Sheet18[NUM])=_max&&_area="c","Yellow")

    The final output is below:

    Best Regards,
    Dino Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

BIswajit_Das's avatar
BIswajit_Das
Icon for Impactful Individual rankImpactful Individual
2 years ago

Hello amitchandak thanks for responding.
But If possible can you give an example regarding this query
i. e How to add color formating on a matrix based on the above senario.
Thanks & Regards...

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi BIswajit_Das ,

Please refer to the steps:
I create a measure by using this DAX:

Measure 2 = var _tab=SUMMARIZE(ALLSELECTED('Table (2)'[area]),'Table (2)'[area], "@sumvalue",CALCULATE(SUM('Table (2)'[value])))
var _max= maxx( _tab,[@sumvalue])
var _area=SELECTEDVALUE('Table (2)'[area])
return  SWITCH(TRUE(),sum('Table (2)'[Value])=_max&&_area="a","Blue", sum('Table (2)'[Value])=_max&&_area= "b","Black",sum('Table (2)'[Value])=_max&&_area="c","Yellow")



Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • BIswajit_Das's avatar
    BIswajit_Das
    Icon for Impactful Individual rankImpactful Individual
    2 years ago

    HelloAnonymous 
    Thanks for responding but can you edit the measure for this data
    PCNONUMRES

    11A
    12A
    13B
    14A
    25B
    26C
    27A
    28B
    39C
    310A
    311C
    312C

    here the measure is like 

    i.e
    In rows - pcno

    columns - res

    values - count(num)
    Thanks & regards..

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi BIswajit_Das ,

      Sorry for being late, please change the DAX into this:

      Measure = var _tab=SUMMARIZE(ALLSELECTED('Sheet18'[RES]),'Sheet18'[RES], "@sumvalue",CALCULATE(COUNT(Sheet18[NUM])))
var _max= maxx( _tab,[@sumvalue])
var _area=SELECTEDVALUE('Sheet18'[RES])
return  SWITCH(TRUE(),COUNT('Sheet18'[NUM])=_max&&_area="a","Blue", COUNT('Sheet18'[NUM])=_max&&_area= "b","Black",COUNT(Sheet18[NUM])=_max&&_area="c","Yellow")

      The final output is below:

      Best Regards,
      Dino Tao
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.