Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Hasvine2022
Helper I
Helper I

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:

TicketCover
128711
128742
128742
128724
128724
128724
128724
128761
128711
128724

 

My final result should be like the below:

TicketCover
128711
128724
128742
128761
Total8

 

Is there a way I can do it?

 

Thank you.

1 ACCEPTED SOLUTION
Jihwan_Kim
Super User
Super User

Hi,

Please check the below picture and the attached pbix file.

 

Jihwan_Kim_0-1665554156391.png

 

 

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.


Go to My LinkedIn Page


View solution in original post

2 REPLIES 2
Jihwan_Kim
Super User
Super User

Hi,

Please check the below picture and the attached pbix file.

 

Jihwan_Kim_0-1665554156391.png

 

 

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.


Go to My LinkedIn Page


Hi Jihwan,

 

It works, thank you.

 

Kind Regards

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.