New measure

[igiiwe]

Hi everyone,

I am new to Power BI and DAX. The diagram was what I was able to design. I would like to do the following calculation but i dont know how to go about it, any little help will really go a a long way.

I would like to Calculate

1) alarms per day/week/month (per XXX-turbine-atrribute)

2) new alarms per day/week/month

Thanking you all in advance

[v-lili6-msft]

hi, @igiiwe

You may just use COUNTA Function to create two simple formula as below:

alarms=CALCULATE(COUNTA(Alert ID))

and 

new alarms=CALCULATE(COUNTA(Alert ID), Type="new")

then darg the date field into axis and use Drill mode in a visualization in Power BI.

Reference:https://docs.microsoft.com/en-us/power-bi/consumer/end-user-drill

If it is not your case, Could you please share your sample pbix file or some data sample and expected output . You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.

Best Regards,

Lin