Measure with no filters on a table

[panchinxd]

Hey guys!

So i have been working on a proyect so im stuck right know! it seems to be soo easy so i hope someone can help me!

Object	Sales
Table	200
Chair	550

and the same thing on 

Object	Sales
Computer	1000
Mouse	350

So total sales are: 2100

so i would like to divide the total sales / computers for example! but when i add the total sales to the table! it gives me a weird number, so it seems to come with filters! can anyone know of to get the filters off, or what should i do!

Thank you very much!

[panchinxd]

So let me start again!

i have a measure that sum total sales from 2 tables with this code:

Cartera Total- = CALCULATE(SUM('Mega reporte Prestamos'[SALDOCAP.]);FILTER('Mega reporte Prestamos';'Mega reporte Prestamos'[ESTADO] = "VENCIDO" || 'Mega reporte Prestamos'[ESTADO] = "VIGENTE")) + CALCULATE(SUM('Megareporte Tarjetas'[Saldo Capital Contable]);FILTER('Megareporte Tarjetas'; 'Megareporte Tarjetas'[Estado Contable] = "VENCIDO" || 'Megareporte Tarjetas'[Estado Contable] = "VIGENTE"))

So that give me the total sales with some filters, the total is on a card on the right side of the following picture

So when i add the total to the following table, i would like to have the same total! for each row

[Anonymous · Accepted solution]

Hi @panchinxd ,

Please try to use ALL() function, modify your formula as below.

Cartera Total- = CALCULATE(SUM('Mega reporte Prestamos'[SALDOCAP.]);FILTER(ALL('Mega reporte Prestamos');'Mega reporte Prestamos'[ESTADO] = "VENCIDO" || 'Mega reporte Prestamos'[ESTADO] = "VIGENTE")) + CALCULATE(SUM('Megareporte Tarjetas'[Saldo Capital Contable]);FILTER(ALL('Megareporte Tarjetas'); 'Megareporte Tarjetas'[Estado Contable] = "VENCIDO" || 'Megareporte Tarjetas'[Estado Contable] = "VIGENTE"))

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

The information you have provided is not making the problem clear to me. Can you please explain with an example. If possible please share a sample pbix file after removing sensitive information.
Thanks.

My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-wi...
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

[Anonymous]

Hey @panchinxd 

I'm not entirely clear on what you are asking for. Can you post a screen shot of your visual and what what you are trying to accomplish.

Based on what you stated I believe you are looking for the SUMX function: https://docs.microsoft.com/en-us/dax/sumx-function-dax

So your measure would be: Measure = SUM(table[Sales])/SUMX(table[Object]="Computer",Table[Sales])

If you are looking for a way to ignore applied filters you will need to use the ALL() function around the SUMX function. Examples found here: https://docs.microsoft.com/en-us/dax/all-function-dax

If this helps please kudo.

If this answers your question please accept it as a solution.