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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
_chris_
Helper II
Helper II

Problem with Measure

Hi, I have a simple question I am struggling with:
 
I have two tables which have proper relationship. One is for time booking, the other is for the headers of the time bookings (ProjectPositions).
 
I am of the opinion, I did a proper measure:
 
PT = CALCULATE(SUMX(employeeHrs, employeeHrs[Hrs]/8), dimProjects[InvoicingKey]="nA", employeeHrs[toInvoice]=TRUE)
 
However, when I add the field Abrechnung (=InvoicingKey) to my table, the one ProjektPosId gets repeated with multiple invoicing keys while there is only one row in the database.
 
_chris__0-1675104441467.png_chris__1-1675104493548.png

It would be really nice if someone could help and explain to me what I am doing wrong.

 

Thx Christian

1 ACCEPTED SOLUTION
marcelsmaglhaes
Super User
Super User

Hey @_chris_ !

Try the measure below.

PT = 

CALCULATE(

SUMX(employeeHrsemployeeHrs[Hrs]/8), 
FILTER(dimProjects, dimProjects[InvoicingKey]="nA"),
FILTER( employeeHrs, employeeHrs
[toInvoice]=TRUE)
)

If this helps, please mark this question as solved to help people find quickly in our community!

Regards,
Marcel


Regards,
Marcel Magalhães
Microsoft Power BI Official Partner
MCT | Certified PL-300 Power BI

If I've helped, don't forget to mark my post as a solution!
Imagem de fundo



View solution in original post

2 REPLIES 2
_chris_
Helper II
Helper II

Hi Marcel,

 

thanks a lot for your quick response. It works fine. I guess I have to go back and do my homeworks to understand why my solution did not work.

 

Thanks again!

 

Christian

marcelsmaglhaes
Super User
Super User

Hey @_chris_ !

Try the measure below.

PT = 

CALCULATE(

SUMX(employeeHrsemployeeHrs[Hrs]/8), 
FILTER(dimProjects, dimProjects[InvoicingKey]="nA"),
FILTER( employeeHrs, employeeHrs
[toInvoice]=TRUE)
)

If this helps, please mark this question as solved to help people find quickly in our community!

Regards,
Marcel


Regards,
Marcel Magalhães
Microsoft Power BI Official Partner
MCT | Certified PL-300 Power BI

If I've helped, don't forget to mark my post as a solution!
Imagem de fundo



Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.