Want to show all column values even if measure returns blank, but respect filters

[twilkins]

Hi.  I have a tableAccount Managers) that uses a slicer(Regions), but only shows rows for which the measure(Total Bill Extras) has a value to calculate.  What I want is for the table to still show all 'Account Managers'[Full Name] filtered with the Region Slicer even if there is no value to calculate.  

Tables:  'Account Managers', 'Bill Extras', 'Regions'

Relationships: 'Account Managers'[Region] - 'Regions'[Region]

                       'Account Managers'[TMID] - 'Bill Extras'[TMID]

                       'Bill Extras'[Month] - 'Months'[Month]

Here is the full list of managers in Region 50

Here is what happens when I bring in the "Total Bill Extras" measure.  It only gives me those managers from Region 50 who have data in the 'Bill Extras' table with respect to the filters applied by the slicers.

Total Bill Extras = CALCULATE(SUM('Bill Extras'[RevenueAmount]))

What I want is to keep all managers from Region 50 in the table and show $0 if there is no data, but I don't want managers from other regions to show up.

Any ideas?  

PS - My first time posting 🙂

[SilviaM]

Hi All, 

   I have the same issue, I have already tried the suggestion "Show items with no data" option in the column but it's not working.

   I explain below what I have:

   I have a measure to get the total of alerts and in case the result is 0 instead it shows as Blank, it shows as 0  

      Total Alerts =

      var _alerts=COUNTROWS('Reporte Alerts')

       return

       if(ISBLANK(_alerts),0,_alerts)

   An I'm using this measure in a matrix where I need to show the information about the ID, the month, Link Primary or Secondary, but if there were no any alert in an specific month it shows as blank and not 0, i have set the option in the rows and colums "Show items with no data" without any luck.

   Any idea why? please help!!

[amitchandak]

@twilkins , Try to add +0 to measure

Total Bill Extras = CALCULATE(SUM('Bill Extras'[RevenueAmount])) +0

Or use this option

[twilkins · Accepted solution]

Awesome!  I used the second option "Show items with no data".  Thank you so much @amitchandak!