Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
x0
Helper I
Helper I

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. 

x0_1-1705931166931.png

 

 

5 REPLIES 5
jdbuchanan71
Super User
Super User

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.

 

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. 

jdbuchanan71
Super User
Super User

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.

jdbuchanan71_0-1705932053564.png

 

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 ? 

x0_0-1705999958266.png

x0_1-1706000074098.png

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  

 

Hello @jdbuchanan71 

 

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

x0_0-1706000445949.png

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

 

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.