countif measures from Microsoft live connection to Premium Capacity metrics

[ucek]

Hi,

I am using the Capacity Metrics dataset from Microsoft and building a more suitable report for me. I would like to count number of occurences when sum of measures [xBackground %] and [xInteractive %] is grater than 1. In this example I should get the result of 2 as you can see on the chart. I am struggling to build a DAX measure to have this calculated. Unfortunately I can not build tables, just measures.
Any suggestions?

[vapid128]

Click your visual,

ON the right side of your screen, find "filter".

Find [xInteractive %] , set up greater 1.

[tamerj1 · Accepted solution]

Hi @ucek 

please try

SUMX (

    VALUES ( TimePoint ),

    IF ( [xBackground > 1, 1 )

)