Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Create new column or measure

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.

 

 

 

 

Need Help
  • DataInsights's avatar
    DataInsights
    4 years ago

    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"
)

     

     

4 Replies

  • DataInsights's avatar
    DataInsights
    Icon for Super User rankSuper User
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      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's avatar
        DataInsights
        Icon for Super User rankSuper User
        4 years ago

        Anonymous,

         

        Would you provide an example of the desired result?