DAX Calculation - Open Value - Subcontractor Value in Dynamics360 CRM

[Anonymous]

Hello!

I am wondering if someone out there can help me with this calculation I am having trouble with.
I'm sure it's a quick fix, but Monday is hitting hard this week.

So, I am looking to get the Open Contract Value for our Sales Pipeline data to reflect the Open Contract Value without the contract lines designated as Subcontractors. 

Below is the measure I have for Open Contract Value that is validated correct:

Open Value = CALCULATE(SUM ( vs360_contractline[Contract Value]),vs360_contractline[Status Reason] = 1) + 0

This is what I have for the Open Value that are not Subcontractor Values:

Open Value - Sub = CALCULATE(
     SUM ( 
           vs360_contractline[Contract Value]),vs360_contractline[Status Reason] = 1, ISTEXT(vs360_contractline[new_subcontractor] = TRUE)) + 0 This measure only gives me $0.

 The [new_subcontractor] values are True or False in the column. 

This measure is giving me $0.

Any assistance or constructive comments are welcome!

Please be nice. ❤️

-Nat

[Joe_Barry]

Hi @Anonymous 

You should use the Open Value measure in the new measure, it helps to track back if any changes need to be made. So you say the vs360_contractline[new_subcontractor] has either TRUE or FALSE in the column?

Open Value _ Sub =
CALCULATE([Open Value],
  KEEPFILTERS(vs360_contractline[new_subcontractor] = TRUE())

Joe