Forum Discussion

Icon for Post Patron rank

Post Patron

7 years ago

Measure with Variables and Filters

Hi, I have simpliefied my example. I want to calculate the number of E-Mail Opens with a filter for "Welcome-Phase". Of course there are other phases as well such as "Follow Up". It works fine thoug...

Icon for Community Champion rank

Community Champion

7 years ago

By putting the column [Phase] in a matrix/table, you are adding the filters implicitly in the visualization and don't need them in the measure.

So your code should be

SCORE = 
VAR score =
    CALCULATE(
        [mailing-opens] ;
        [Art] IN {"Initial"}
        )

RETURN
score

(if you are putting [Art] in the visual as well, you can remove the measure altogether as you would just use [mailing-opens] as the value

Hope this helps

David

raymond
Post Patron
7 years ago
dedelman_clng Thank you.

However, what if the following is the case :)

SCORE = VAR scoreA = CALCULATE( [mailing-opens] ; [Phase] IN {"Welcome-Phase"} ; [Art] IN {"Initial"} ) VAR scoreB CALCULATE( [mailing-klicks] ; [Phase] IN {"Welcome-Phase"} ; [Art] IN {"Result"} ) RETURN scoreA + scoreB

What I hope to see in a matrix table is the Result of scoreA + scoreB for the "Welcome-Phase" and in a drill down to "Art" the separate values for "Result" and "Initial"
- dedelman_clng
  Community Champion
  7 years ago
  Can you provide a sample of data and your expected results?
  - raymond
    Post Patron
    7 years ago
    Sure. I have uploaded a sample to dropbox. click here
    
    It is a quite simple case. There E-Mailings and Phases. I want to calculate a score for E-Mail A and E-Mail B. The scores are different. Hence on the level of the Initial Phase the value is correct. In the drill down the values are not. Furthermore under Results the same value is shown. This should be 0.
    
    For A and B and the score on the initial level the values should be as such: