Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Sign up nowGet Fabric certified for FREE! Don't miss your chance! 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.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 62 | |
| 61 | |
| 42 | |
| 21 | |
| 18 |
| User | Count |
|---|---|
| 122 | |
| 116 | |
| 38 | |
| 32 | |
| 29 |