Solved: Formula

Anonymous · ‎10-11-2022

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:

My final result should be like the below:

Is there a way I can do it?

Thank you.

Jihwan_Kim · ‎10-11-2022

Hi,

Please check the below picture and the attached pbix file.

Cover measure: =
SUMX ( DISTINCT ( Data[Ticket] ), CALCULATE ( DISTINCT ( Data[Cover] ) ) )

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

Jihwan_Kim · ‎10-11-2022

Hi,

Please check the below picture and the attached pbix file.

Cover measure: =
SUMX ( DISTINCT ( Data[Ticket] ), CALCULATE ( DISTINCT ( Data[Cover] ) ) )

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

Anonymous · ‎10-11-2022

Hi Jihwan,

It works, thank you.

Kind Regards

Formula