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

hohlick's avatar
hohlick
Icon for Continued Contributor rankContinued Contributor
9 years ago
=COUNT(TableName[id])+0