Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |