Forum Discussion
Add Missing items with null/blank/0
Hi Community, I have a table with 3 columns, Name is slicer in my report. If i select Bala it will show all 4 region details of bala. If i select Dhanpal or Sudhakar it needs to show all 4 regio...
Anonymous , You have create a measure with +0. Also change data type sales to number
Please find the file attached after signature. Check for Measure 2
Hi Anonymous,
I think you need to create a calculated table with all region values and use it on your visual with the raw table category. Then you can write a measure formula to lookup value based on current category and region, use the if statement to replace the not matched value to blank.
Regards,
Xiaoxin Sheng