Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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.
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.
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.
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
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.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 36 | |
| 33 | |
| 31 | |
| 28 |
| User | Count |
|---|---|
| 129 | |
| 88 | |
| 79 | |
| 68 | |
| 63 |