Forum Discussion

3 Replies

  • dax's avatar
    dax
    Community Support
    6 years ago

    Hi j_martinho,

    It seems that you want to calculate sum based Area desbloqueio, when you add this field in Table and add Pago, it will automatically calculate sum for you

    In addition, you could try below measure to calculate count

    Measure 4 = CALCULATE(COUNT('Table'[Area desbloqueio]), ALLEXCEPT('Table','Table'[Area desbloqueio]))

    By the way, if possible, could you please inform me the error in English and explain the logic of below(count?)

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • j_martinho's avatar
      j_martinho
      Helper I
      6 years ago

      Hi dax 

       

      I have in the source table the ID that would be "Documento" and respectively two columns containing one the release location ("Area Lancamento") and the other the unlock location ("Area Desbloqueio"). I want to calculate the total sum by location and the amount of releases and unlocks by location.

      I enter the "Area Lancamento" column in Visual, then a new columm DistinctCount "Area Lancamento", and when I enter DistinctCount for "Area Desbloqueio" the total per area of ​​the two columns is the same.

      I have tried some DAX fomulas without success.

       

      Valor Pago = SUM "Valor Pago"

      Qtd Lancamentos = Distinctcount "Area Lancamento"

      Qtd Desbloqueios= Distinctcount "Area Desbloqueio"

       

      Error using ADDCOLUMNS or SUMMARIZE: The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value

       

      Data Source Sample: https://1drv.ms/x/s!AuUNmh5pyq5g93rKg_a-sEJWzfc_?e=AzWweb

      • dax's avatar
        dax
        Community Support
        6 years ago

        Hi j_martinho, 

        I am sorry for late reply, I am not clear about your requirement. If you want to count distinct based on Area Lancamento and Area Desbloqueio, you could try to use below

        Measure 7 = DISTINCTCOUNT(Table1[Area Desbloqueio])
Measure 8 = DISTINCTCOUNT(Table1[Area Lancamento])

        If possible, could you please inform me your expected output? Then I will help you more correctly.

        Best Regards,
        Zoe Zhi

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.