Total in Visual (like count if Excel)

[j_martinho]

I need a resume table like Excel using count.If

Visual in Power BI needed:

I tried:

Database example: https://1drv.ms/x/s!AuUNmh5pyq5g93rKg_a-sEJWzfc_?e=AzWweb

[dax]

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]

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]

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.