Forum Discussion

IsmaelConsult's avatar
IsmaelConsult
Frequent Visitor
3 years ago

Wrong Total

How can i fix my total in a matrix.       The expresions are: Saldos:= CALCULATE(SUM(Saldos[Entrada])-SUM(Saldos[Saida])) Estoque:= VAR DATAINI=FIRSTDATE(ALL('Calendar'[Data])) VAR ...
General Comment
Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

Please describe the question, share data in a format that can be pasted in an MS Excel file and show the expected result.  If possible, could you share the column names in English language?

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    3 years ago

    Hi,

    You may downlaod my PBI file from here.  I have also simplified your measures

    Hope this helps.

    • IsmaelConsult's avatar
      IsmaelConsult
      Frequent Visitor
      3 years ago

      "Good job, But I need to check the balances from previous periods as well. For example: Click on the year 2022, month of August, and be able to see the physical and financial retroactive balance.

      However, with these measures, when I filter a year and month, the data only calculates the information for the selected period."

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        3 years ago

        Thank you.  That is a new requirement.  Not in any previous post have you mentioend that.  Explain your new requirement very clearly.  Show the expected result.