Forum Discussion

Maffimau's avatar
Maffimau
Frequent Visitor
9 years ago

Powerbi.com Server Time

Hi, I did a big report with a lot calculation based on now() function (hour, average time for a operation, ecc..). After published the report I dicover that the database are in Irland -2 hours from ...
Need Help
v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi Maffimau,

Can I "simulate" or "forced" a value "0" when I have no dates or without rows?

Could you try adding "+ 0" to the end of the formula of your measure to see if it works? :smileyhappy:

measure = COUNT(<column>) + 0

 

Regards

Maffimau's avatar
Maffimau
Frequent Visitor
9 years ago

Hi, thanks for the suggest but I tried and I can not do it because:

I have a clumn that is a result from a sql tabel throw 5 filters! So if I use the function "count" the result is from the original table without filters; does it mean that the result have to be "1" (from the table with filters), but with "count" function the result is 96K.

I don't know if there is a trick to "count" with few filters in the same function, and the filters come from interrogation to others table of sql.

Thanks