Forum Discussion

aj1107's avatar
aj1107
Icon for Advocate I rankAdvocate I
9 years ago
Solved

Display zero instead of blank in matrix

  Need to dsiplay zero  instead of blank in matrix. Though it looks simple, am struggling to get it done. Heres the sample record.   id,name,status 1,a,s 1,b,h 2,d,s   Output in power bi. Nee...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    aj1107

     

    Hi, you can obtain this view following these steps:

     

    1.Create a new Table (Modeling-New Table)

     

    Tablepr=Distinct(Table1[pr]

    2. Related both tables

     

    3. Create the Measure to Count IDs

     

    CountIDs=Count(Table[id]) + 0

     

    Ready

     

    Matrix Visual

aj1107's avatar
aj1107
Icon for Advocate I rankAdvocate I
9 years ago

Hi, I need your help to handle below scenario. I tried to apply the logic using lookup table, however the zero is displayed for all the values in lookup table.

 

Relationship Lookup(Column1)->Lookup(Lkp)

Calculated measure - #cnt=count(id)+0

 

Txn                                                                               Lookup

 

 

 

Since ther matrix is based on lookup table,  zero is displayed for all the lookup values(E-H). Isit possible to restrict rows if all the columns in matrix is zero(not to display). So that slicer by lookup shows only corresponding values in matirx. Right now it dispalys all the lkp values in rows irrespective of Txn values.

 

Thank you.

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi aj1107,

 

I think below are you needed.

Source Tables:

 

Formula:

Analysis = SUMMARIZE(Lookup,[Lkp],"Open",SWITCH(LOOKUPVALUE(Txn[State],Txn[Name],[Lkp]),"Open",1,0),"Closed",SWITCH(LOOKUPVALUE(Txn[State],Txn[Name],[Lkp]),"Closed",1,0))

 

Regards,

Xiaoxin Sheng