Formula

[Anonymous]

Hello Team,

I need your help with a formula. I need to calculate the number of covers per Ticket. The database shows the data as per below:

Ticket	Cover
12871	1
12874	2
12874	2
12872	4
12872	4
12872	4
12872	4
12876	1
12871	1
12872	4

My final result should be like the below:

Ticket	Cover
12871	1
12872	4
12874	2
12876	1
Total	8

Is there a way I can do it?

Thank you.

[v-yinliw-msft · Accepted solution]

Hi @Anonymous 

You can build a new table to remove duplicates:

DAX:

Table = SUMMARIZE('Sample Table','Sample Table'[Ticket],'Sample Table'[Cover])

And then you can use matrix in the Power BI Desktop:

Is this the result you would expect?

Hope this helps you.

Best Regards,

Community Support Team _Yinliw

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

[amitchandak]

@Anonymous , I visual use Ticket and cover as not summarized, and this measure

Sumx(summarize(Table, Table[Ticket], Table[Cover]), [Cover])