Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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 ...
Need Help
Show and Tell
Tips and Tricks
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    Please check the below picture and the attached pbix file.

     

     

     

    Cover measure: =
SUMX ( DISTINCT ( Data[Ticket] ), CALCULATE ( DISTINCT ( Data[Cover] ) ) )
Jihwan_Kim's avatar
Jihwan_Kim
Super User
3 years ago

Hi,

Please check the below picture and the attached pbix file.

 

 

 

Cover measure: =
SUMX ( DISTINCT ( Data[Ticket] ), CALCULATE ( DISTINCT ( Data[Cover] ) ) )
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Jihwan,

     

    It works, thank you.

     

    Kind Regards