I need a measure with a calculation of Revenue with some filters but i am not sure how to do this. I know this is possible in the visual filters, but I need to add another calculation to this one after it that is why I need it in a measure.
I need the sum from Revenue
Which contains or starts with "BV" from Order
And starts with "PA" from Note
I was trying something with CALCULATE(SUM( )) and FILTER and FIND() but obviously not getting the results I want.
Below the sample data, at the end I only need the €61, €23 and €65 below.
Thanks in advance!
Solved! Go to Solution.
Sample data please.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Proud to be a Datanaut!