Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Report about missing data.

Hi there,   I have a report with 10 states out of which 3 states have data. I would like to provide information and metrics about the remaining 7 states (states that have no data). However PBI curr...
Need Help
Show and Tell
  • ppm1's avatar
    ppm1
    3 years ago

    You can choose "Show Items With No Data" on your Region field.

     

     

     

    Pat

ppm1's avatar
ppm1
Solution Sage
3 years ago

You can choose "Show Items With No Data" on your Region field.

 

 

 

Pat

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thanks Pat. That helps.

     

    Update: I was able to figure it out. I had achieve it by 2 step process. Do a left join and then create calculated column within the same table instead of referencing across tables. 

     

    Not sure if you got a chance on the pie. The value should be 7 instead of 10. 

    I tried to reference something like below to create a calculcated column on "Data" but not able to reference the relation from other table.

     

    StateWithWithoutData = if(Data[StateCD] = states[StateCD],"withData","WithoutData")