Forum Discussion

x0's avatar
x0
Helper I
2 years ago

Matrix visual do not use visual

Hello Everyone , 

 

ANyone has idea about matrix visual values ? 

 

I dont want to use SUM for any column i add in value but its automatically sum my value. i want to as like table visueal which has feture to dont summrize. just because of this i am getting wrong value. 

 

 

Need Help

5 Replies

  • jdbuchanan71's avatar
    jdbuchanan71
    Super User
    2 years ago

    Change the aggregation from SUM to MAX.  Because you are adding it to the Values well, it has to do a calculation of some kind.  Using MAX will be the same as not aggregating if the value is the same for all rows.

     

    • x0's avatar
      x0
      Helper I
      2 years ago

      Hello jdbuchanan71 

       

      I did the MAX but unfortunatley i am getting another value bus some value are same can you see whats an issue where is glitch ? 

      or is there any way to create simple messure because these 2 column value comes from calculation of lead conversion new leads ( Application completed divide by New Leads ) and for second column lead conversion first visit ( Application completed dived by First visit/ tour ) each raw  

       

      • x0's avatar
        x0
        Helper I
        2 years ago

        Hello jdbuchanan71 

         

        Please have a look this is i created demo of perticular this table 

        here i am getting perfect value as i use table and i did dont summerize. 

         

  • jdbuchanan71's avatar
    jdbuchanan71
    Super User
    2 years ago

    Yes, you can do it with a measure.  

    New Lead Conversion = MAX ( YourTable[Lead Conversion New Leads] )

    Test that against your sample where you are getting perfect values.

     

    • x0's avatar
      x0
      Helper I
      2 years ago

      hello jdbuchanan71 

       

      I think so i solved this query because i seen somewhere i found relationship issue of multiple tables and common columns lets see.