Slicer not working properly on my Measure

[guyinkits]

Thanks in advance for any help here but I've searched this forum (and elsewhere) for my particular issue but couldn't come up with a solution.

I've got a measure that calculates a %return:

Q1 Income Return = round((1+calculate([Mth Income Return],'IPD Actual'[Month #]=1))*(1+calculate([Mth Income Return],'IPD Actual'[Month #]=2))*(1+calculate([Mth Income Return],'IPD Actual'[Month #]=3))-1,4)

The [Mth Income Return] in the above is also a measure (which doesn't give me any slicer issues):

Mth Income Return = iferror(sum('IPD Actual'[Net Operating Income])/(sum('IPD Actual'[Beginning Market Value])+sum('IPD Actual'[Capital Improvement])),0)

When I apply a slicer for assets of different types, the slicer sort of works but is not working as expected.  For example, if the slicer were by country and I selected Country 1, all assets still show up in the visual however only Country 1 assets will show a value in the return.  All the other assets show zero.  What I was hoping to get was just Country 1 assets.  All the other assets I was hoping to not have appear at all.  In a bar chart format, I am getting a bunch of blank bars.  For some reason, this measure works in Powerpivot when I'm filtering but not in PowerBI. In the screenshot below, I'm hoping to just get the green bars to appear and not the blanks. Any ideas?

[Anonymous]

Have you found a solution for this?

[v-jiascu-msft]

Hi @guyinkits,

1. You can check out if you enable the option "Show items with no data".

2. Can you share more details? The relationships and the columns you used in the visual could cause this issue.

3. Is [Month #] in the visual?

Best Regards,

Dale

[guyinkits]

@v-jiascu-msftThe show items with no data is not selected.  Nothing changes when I select or deslect that option.  Like I mentioned, the relationships seem to work fine.  When I use a regular data column, the drill down works as expected.  When I use a measure instead, that is where my issue pops up.  You can see in the screen shots below that I have bars for only assets with values when I don't use a measure.  But when I use a measure, I get all assets even when it is zero and should be excluded from the drilldown as they have values but to a different drill down group.

[cjayaneththi]

Hi,

Have you got separate table for countries? If not create new table and link the relationship in the data model.

You can create new table using "value" function

[guyinkits]

@cjayaneththi I do have a dimension country table.  The relationships work if I put in a different column like $value but it doesn't work when I put in a measure.  When I put in a column that isn't a measure, onlythe Countries from the drill down show up.  If I use a measure, all countries show up and the ones filtered OUT just show zero.

[cjayaneththi]

would you  be able to share the pbix file? I can have a look