Create new column or measure

[Anonymous]

I am having trouble figuring out the best way to do this task. 

I have 18 duplicate pm_id for a task and if any of those 18 fail in the value column then the whole thing fails.  Would it be best to create a new column or a measure?  Any help would be appreciated.

[DataInsights · Accepted solution]

@Anonymous,

How you intend to use this field will help you determine which approach to use. If you need to slice on this field in a visual (or use it in a slicer), a calculated column will enable you to do so. Here's the DAX for a calculated column:

result = 
IF (
    CALCULATE (
        COUNT ( Table1[pm_template_task_id] ),
        ALLEXCEPT ( Table1, Table1[pm_id] ),
        Table1[value] = "Fail"
    ) > 0,
    "Fail",
    "Pass"
)

[Anonymous]

How would i go about only counting the results for only one PM_ID instead of getting a count of say 4 fails for pm_id 7e54?

[DataInsights]

@Anonymous,

Would you provide an example of the desired result?

[Anonymous]

Here is what i came up with for the measure:
Pass/Fail Count =

CALCULATE(

DISTINCTCOUNT(Query1[pm_id]),

SUMMARIZE(

Query1,

Query1[result]

)

)