Measure Calculate Count values

[timgiefer]

Hi everyone!

I'm new to Microsoft Power Bi but there is the thing I want to do:

I've got a column called "cutting" with 0 (machine isn't working) and 1 (machine is working).

I want to create a measure called "UT" where the amount of rows with "cutting" = 1 is divided by the total amount of columns in the table 'Tabelle1'. The DAX formula is the following:

UT = CALCULATE(COUNT('Tabelle1'[cutting])/COUNTROWS('Tabelle1'); 'Tabelle1'[cutting] = 1)

When I try to display the measure on my dashboard, the field is blank.

I have already looked at different forum posts similar to my problem, but nothing seems to work.

Can anyone help?

Thanks

Tim

[BeemsC · Accepted solution]

Hey @timgiefer,

Try it with the following measure: 

UT = DIVIDE(CALCULATE(COUNT('Tabelle1'[cutting]);Tablelle1[Cutting] = 1);COUNTROWS('Tabelle1'))

Might be a "" wrong, but should be fine.
Good luck !

[timgiefer]

Hi @BeemsC

Thanks for your answer, but the result is still a blank ...

[BeemsC]

What are you using to show the data ?
And what happens when you filter out the blanks using the Visual level filters

[timgiefer]

---

@BeemsC

I checked the DAX-formula again, I made a mistake by taken the wrong column name... my bad!

Thanks for your help!!

Tim

[v-chuncz-msft]

@timgiefer,

Since your problem has been resolved, please help accept solution. Your contribution is highly appreciated.