Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
lebiodalukasz
Frequent Visitor

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

 

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?
problem1.PNG
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.
problem2.PNG
1 ACCEPTED SOLUTION
lebiodalukasz
Frequent Visitor

7 REPLIES 7
lebiodalukasz
Frequent Visitor

GOT IT RESOLVED FOLLOWING THIS:

 

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

 

fhill
Resident Rockstar
Resident Rockstar

 

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




Did I answer your question, or help you along the way?
Please give Kudos or Mark as a Solution!


https://www.linkedin.com/in/forrest-hill-04480730/

Proud to give back to the community!
Thank You!




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)_]) 

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)_ ?




Did I answer your question, or help you along the way?
Please give Kudos or Mark as a Solution!


https://www.linkedin.com/in/forrest-hill-04480730/

Proud to give back to the community!
Thank You!




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.

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?)




Did I answer your question, or help you along the way?
Please give Kudos or Mark as a Solution!


https://www.linkedin.com/in/forrest-hill-04480730/

Proud to give back to the community!
Thank You!




i already tried and it does what it does now.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.