New to DAX and Struggling with Filtering

[Kayla2501]

Hi All, 

Hopefully I can get some help. I have taken over a dashboard in my new job and my skills in DAX need some work. 

I basically need to multiply Cost by Confidence factor if status date = current. 

This is what I have so far which is incorrect but seem stuck. 

Measure =

Var x = [Current Status (Date)]

CALCULATE(

SUMX('P6 Cashflow', 'P6 Cashflow'[Cost]) * SUMX('Project Status Outputs', 'Project Status Outputs'[Confidence Factor])

FILTER('Project Status Outputs'[Status Dates] = var x)

)

[Anonymous · Accepted solution]

Hi  @Kayla2501 ,

I created some data:

P6 Cashflow：

Project Status Outputs：

Here are the steps you can follow：

1. Create measure.

Measure_group =
SUM('P6 Cashflow'[Cost])
*
SUMX(
    FILTER(ALL('Project Status Outputs'),
    'Project Status Outputs'[Status Dates]=MAX('P6 Cashflow'[Current Status (Date)])&&'Project Status Outputs'[numbers]=MAX('Project Status Outputs'[numbers])),[Confidence Factor])

2. Result:

If you need pbix, please click here.

If I have misunderstood your meaning, please provide your desired output.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[tamerj1]

Hi @Kayla2501 
How are the two tables related to each other? What are you slicing by in your report? How does your visula look like?

[Kayla2501]

Two tables are related by contract numbers. 

I have no visual or slicer yet but will be contract number and the cost by confidence value

[tamerj1]

@Kayla2501 
Thank you for the clarification. Which table is the one side and which one is the many side?