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

Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi,Related both tables means how  i want to do in modelling tab or through dax?

and what cross filter direction i want to choose.