Forum Discussion
Formula
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.
Hi,
Please check the below picture and the attached pbix file.
Cover measure: = SUMX ( DISTINCT ( Data[Ticket] ), CALCULATE ( DISTINCT ( Data[Cover] ) ) )
2 Replies
Hi,
Please check the below picture and the attached pbix file.
Cover measure: = SUMX ( DISTINCT ( Data[Ticket] ), CALCULATE ( DISTINCT ( Data[Cover] ) ) )