Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Measure formula:
Solved! Go to Solution.
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
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)_ ?
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?)
Proud to give back to the community!
Thank You!
i already tried and it does what it does now.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
97 | |
75 | |
63 | |
62 |
User | Count |
---|---|
135 | |
105 | |
104 | |
80 | |
65 |