Forum Discussion
Sum rows from visual table
Hi I need some help with something that I guess must be very simple but can't figure out. I have this visual object (table) with columns from different tables with quite a complex structure betw...
Not exactly a measure totals problem but the same technique should work. You would need to essentially replicate your table visualization in a table variable in DAX. This Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
My problem is when trying to create a measure at the row level. If I sumx a variable from another table I get an out of memory error.
In the table 'consumo click' this works fine:
F_Calculada = sumx('Consumo Click';'Consumo Click'[PFAnexo__c])But this doesn't:
F_Calculada = sumx('Consumo Click';'Consumo Click'[PFAnexo__c]) - sumx('Cotización de periodo';'Cotización de periodo'[GNF_CVClientePrima_Click__c])"The report ran out of memory, and the application must close"
I just need to add 3 values I'm already seeing in my visual table for each row!
