Measure calculation good in table but not does not calculate total outside the table.

[lebiodalukasz]

Measure formula:

_Reimbursable Value (EUR)_ = if(ISBLANK([_Q.ty scrapped_]*[_Price MTMA (EUR/ KG)_]),0,[_Q.ty scrapped_]*[_Price MTMA (EUR/ KG)_])

It works and calculates correctly in the table but does not show the sum. How can I make this working?

when i select the row with data it shows me the same amount but i want the tile to show me the sum of all data from that table.

[lebiodalukasz · Accepted solution]

GOT IT RESOLVED FOLLOWING THIS:

https://www.youtube.com/watch?v=Rii_6qkLNh8

[fhill]

Check out this article about two possible options to help.  I use 'HASONEVALUE' quite often when I want a Card to show different results depending on a specific selection.  ISFILTERED may help also...

https://mitchellpearson.com/2018/09/24/hasonevalue-vs-isfiltered-in-dax/

Hope this helps point you in the right direction.

Forrest

[lebiodalukasz]

Hi, thanks but when i look at those you sent they are related to a data in tables but my measure calculates 2 other measures - marked in blue and i can not use the formulas you sent me.

_Reimbursable Value (EUR)_ = if(ISBLANK([_Q.ty scrapped_]*[_Price MTMA (EUR/ KG)_]),0,[_Q.ty scrapped_]*[_Price MTMA (EUR/ KG)_]) 

[fhill]

Why not make your CARD a new Measure that's just SUM ( _Reimbursable Value (EUR)_ ).  When you click on just one line, is should FILTER to just that one value and just return _Reimbursable Value (EUR)_ ?

[lebiodalukasz]

Because SUM does not work with measures. It works with columns and one again  - all columns where you can see _ at the beggining means that column values are made of measures.

[fhill]

ok, probably another bad idea.... what happens if you make your CARD just a measure of ([_Q.ty scrapped_]*[_Price MTMA (EUR/ KG)_]) ?    If every row Blanks, maybe it would just show 'null', but as long as one row has data, the Card 'shoudl' SUM the results.   (I think if I remember correctly, it would SUM all Qty Scrapped the * SUM all Price, not sure if that matters based on your data?)

[lebiodalukasz]

i already tried and it does what it does now.