"Heirarchy" issue

[Aron_Moore]

Hello,

Any ideas why this isn't working?

I have a calendar table with YYYYMM and Year of unique values from my facts table:

The tables are not joined. I created measures to calculate the rate filtering to the respective time period to use in pivot/matrix. I've tested and verified the measures work.

My matrix only shows two Years in the columns, 2016 & 2017, but I also have data for 2018.

I drill down from Year to YYYYMM and still no 2018.

However, if I use go to next level or expand all then 2018 shows up.

Thoughts?

[Aron_Moore · Accepted solution]

I figured it out. My uniques were coming from the wrong table and those values didn't/couldn't match to the fact table.

Thanks anyways!