topic countif measures from Microsoft live connection to Premium Capacity metrics in DAX Commands and Tips

countif measures from Microsoft live connection to Premium Capacity metrics

ucek — Fri, 10 Jun 2022 15:25:35 GMT

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?

Re: countif measures from Microsoft live connection to Premium Capacity metrics

tamerj1 — Fri, 10 Jun 2022 16:53:01 GMT

Hi ucek

please try

SUMX (

VALUES ( TimePoint ),

IF ( [xBackground > 1, 1 )

)

Re: countif measures from Microsoft live connection to Premium Capacity metrics

vapid128 — Fri, 10 Jun 2022 18:13:25 GMT

Click your visual,

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

Find [xInteractive %] , set up greater 1.