Forum Discussion

easyleesie's avatar
easyleesie
Icon for Helper I rankHelper I
6 years ago
Solved

Measure not responding to filter

Hi all   New user here. Apologies if this is a stupid question.   I have a measure calculating monthly cumulative, but when I put it in a box, it gives the total for the selection against each po...
Need Help
  • edhans's avatar
    edhans
    6 years ago

    Glad to help easyleesie 

     

    The Star Schema is critical for Power BI to do modeling and analysis right. The rookie mistake is to go grab tables, pull them in, and start creating visuals. And it makes it worse the Power BI Desktop tool encourages this. Another good reference is this article, and SQLBI also has a book on just data modeling called "Analzying Data with Microsoft Power BI and Power Pivot in Excel."

edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
6 years ago

I'd need to see the PBIX file to really go further. The issue is you don't have a Star Schema and this is making it difficult to write the correct measure, and it is possible it is impossible to write the correct measure depending on how the data is.

easyleesie's avatar
easyleesie
Icon for Helper I rankHelper I
6 years ago

Ok cool. Thanks edhans. That's a useful link. Let me go back to the drawing board. Like I said: I'm new to this...

 

Thanks for your replies.

  • edhans's avatar
    edhans
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Glad to help easyleesie 

     

    The Star Schema is critical for Power BI to do modeling and analysis right. The rookie mistake is to go grab tables, pull them in, and start creating visuals. And it makes it worse the Power BI Desktop tool encourages this. Another good reference is this article, and SQLBI also has a book on just data modeling called "Analzying Data with Microsoft Power BI and Power Pivot in Excel."