Placeholder error

[JamesBurke]

Hi All , 

I'm looking for a measure to count the amount of buildings that exceed a threshold of one so i can count how mnay meters were active yesterday. 

Online Buildings = CALCULATE(DISTINCTCOUNT(FactUWP[Grouped]),if([Total Consumption Todays Usages] > 1 ,1,0))

I'm using below but getting the error a function placeholder has been used in a True/False Expression ?

Any help would be Appericated 🙂

[SamWiseOwl · Accepted solution]

Hi @JamesBurke 

Two methods you coud try, one filtering the data and the other using an iterator function.

Online Buildings Filter=
Calculate(

DISTINCTCOUNT(FactUWP[Grouped])

Filter(FactUWP, [Total Consumption Todays Usages] > 1)
)

Countx values =
SUMX(
Values( FactUWP[Grouped] )

, if([Total Consumption Todays Usages] > 1 ,1,0)

)

The error is because you aren't saying what you want to do with the IF statement.

[v-aatheeque]

Hi @JamesBurke ,

We haven’t heard back from you regarding our previous response and wanted to check if your issue has been resolved.

If it has, please consider clicking “Accept Answer” and “Yes” if you found the response helpful.
If you still have any questions or need further assistance, feel free to let us know — we're happy to help!

Thank you!

[v-aatheeque]

Hi @JamesBurke 

If a community member's response addressed your query, please consider marking it as Accepted Answer and click Yes if you found it helpful.

If you have any further questions, feel free to reach out.
Thank you for being a valued member of the Microsoft Fabric Community Forum!

[v-aatheeque]

Hi @JamesBurke ,

We haven’t heard back from you regarding our previous response and wanted to check if your issue has been resolved.

If it has, please consider clicking “Accept Answer” and “Yes” if you found the response helpful.
If you still have any questions or need further assistance, feel free to let us know — we're happy to help!

Thank you!