DAX Filter

Anonymous 

No worries.  I'm learning just like you.

To clarify, you CAN create CC's (Calculated Columns) in the 'Times' table.

I was simply saying that the result won't look like your screenshot of desired results.

- Your desired result screenshot presents 5 rows of data on only 3 rows (Grouping By Order No. & Milestone)

- The data table 'Times' does not group because it's a data table.

Regardless, below is how to create the CC's:

NOTE: When creating multiple CC's in the same table (which use CALCULATE), this creates a Circular Dependency.  To get around this you have to use ALLEXCEPT.

Here is the data view of the 'Times' table along with the 2 added CC's.

Hope this is helpful to you.

Nathan