Forum Discussion

mikekolba's avatar
mikekolba
Frequent Visitor
7 years ago
Solved

Assistance needed with a Measure/Query

I currently have the following measure   Current Revenue = CALCULATE( SUM(Query1[Column2]), FILTER(Query1,SEARCH("Current",Query1[Source.Name],,0)), FILTER(Query1,Query1[Column1]="Revenue") ) ...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    mikekolba you can change like this.

     

    Current Revenue = CALCULATE(
MAX(Query1[Column2]),
FILTER(Query1,SEARCH("Current",Query1[Source.Name],,0)),
FILTER(Query1,CONTAINSSTRING( Query1[ColumnToSearch], "_")
)
parry2k's avatar
parry2k
Super User
7 years ago

mikekolba you can change like this.

 

Current Revenue = CALCULATE(
MAX(Query1[Column2]),
FILTER(Query1,SEARCH("Current",Query1[Source.Name],,0)),
FILTER(Query1,CONTAINSSTRING( Query1[ColumnToSearch], "_")
)