DAX issue. Fact table with missing dimension attributes members RRS feed

  • Question

  • 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.



    Friday, August 14, 2020 12:56 PM

All replies

  • Hi Mike,

    Yes, you need to specify for each of the 8 measures to get it work for each of them.

    ""SQL Server related"" forum will be migrated to a new home on Microsoft Q&A SQL Server!
    We invite you to post new questions in the "SQL Server related" forum’s new home on Microsoft Q&A SQL Server !
    For more information, please refer to the sticky post.

    Monday, August 17, 2020 1:41 AM