none
filter problem in a calculate function RRS feed

  • Question

  • Hello ! 

    I don't understand why my measure in Power Bi for Desktop doesn't work : it is a calculate function with a filter function (as I saw here: https://msdn.microsoft.com/fr-fr/library/dn727121.aspx )

    As you can see below, I would like to see the sum of amount only if the day corresponds to the last day in my database (here the last day is Wednesday, so day 3, and in the first table we can see that the amount is 886K and not 6,76M which corresponds to the total of all amounts !) What is wrong in my formula?

    Thanks !!

    Thursday, February 25, 2016 1:56 PM

Answers

  • Hi, jessicaf31v2

    This is the forum to discuss questions and feedback for Excel for Developers, since this issue is related to Power Bi for Desktop, I suggest that you could post your question to Microsoft Power BI Community
     
    http://community.powerbi.com/

    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us.
    Thanks for your understanding.

    • Marked as answer by David_JunFeng Saturday, March 5, 2016 3:15 PM
    Friday, February 26, 2016 8:56 AM

All replies

  • Hi, jessicaf31v2

    This is the forum to discuss questions and feedback for Excel for Developers, since this issue is related to Power Bi for Desktop, I suggest that you could post your question to Microsoft Power BI Community
     
    http://community.powerbi.com/

    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us.
    Thanks for your understanding.

    • Marked as answer by David_JunFeng Saturday, March 5, 2016 3:15 PM
    Friday, February 26, 2016 8:56 AM
  • ok thanks a lot !
    Friday, February 26, 2016 10:41 AM