04-12-2018 06:49 AM - edited 04-13-2018 07:32 AM
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.
04-12-2018 07:31 AM
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
Did I answer your question? Mark my post as a solution!
Proud to be a Datanaut!
04-20-2018 04:30 AM
The solution provided earlier was if BV and PA are at starting position and here is another one if they fall between the text.
CALCULATE(AVERAGE(TableName[Revenue]),FILTER(TableName,FIND("BV",TableName[Column 1],1,0) > 0 && FIND("PA",TableName[Column 1],1,0) > 0))
check the brackets if i missed any at closing and hit some kudos if this worked and helped.