DAX issue. Fact table with missing dimension attributes members

• Question

• 

  

  0

  Sign in to vote

  I have a fact table has a sales measure with accounts, numbered 1 though 100 for example.  My dimension table only has accounts 20 through 30.  

  In Power BI when I view by sales measure by my accounts dimension, I have a blank line at the top with the value of the accounts that are not in the dimension table.  Its kinda like a left outer join.  I want to see only the accounts 20 - 30, like an inner join.

  In my DAX I use filter and <> blank().  That's works for that measure, but I have a grid with 8 measures.  Do I need to have add that DAX to all 8 measures?  And in other analysis I need those other accounts?

  Any help appreciated.

  Thanks,

  Mike

  Friday, August 14, 2020 12:56 PM