Forum Discussion

PatrickF2002's avatar
PatrickF2002
Regular Visitor
3 years ago

Adding 0's to power BI Data

So essentially, I have a set of data for a store that includes cash registers 1-15, with the numerical amount of transactions that occur at these registers for each hour they are operational. My prob...
Need Help
ray_aramburo's avatar
ray_aramburo
Icon for Super User rankSuper User
3 years ago
TransactionsCount = 

var tcount = COUNT('Insert your table name here'[register_id])

RETURN

IF(ISBLANK(tcount), 0, tcount)

 

After created add all those columns to the table visual plus the created measure (this created measure would replace txns column)

PatrickF2002's avatar
PatrickF2002
Regular Visitor
3 years ago

So I tried your formula, and I got an error reading this-

 Any advice on how to fix?

  • ray_aramburo's avatar
    ray_aramburo
    Icon for Super User rankSuper User
    3 years ago

    First write the measure name then Alt + Enter and write the var line, then instead of an =, write a RETURN.

    Also, instead of ISBLANK(vregister_count[txns]) write it as (ISBLANK(tcount))

    See example here:

    TransactionsCount = 

var tcount = COUNT('Insert your table name here'[register_id])

RETURN

IF(ISBLANK(tcount), 0, tcount)