Forum Discussion

saud968's avatar
saud968
Memorable Member
2 years ago
Solved

Calculated Column from Measure

I am using this Dax as a measure -  S = CALCULATE(     COUNT('Colleague Events'[SEARCH_ID]),     FILTER(         'Colleague Events',         'Colleague Events'[CAUSE2] IN {"didyoumeanAutomatic...
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • saud968's avatar
    saud968
    2 years ago

    The "Colleague Name" is from another column. However, I was able to resolve the issue by separating the filter. 


    IsDesiredCause =
        'Colleague Events'[CAUSE2] IN {"didyoumeanAutomatic", "didyoumeanClick", "searchboxSubmit",
                                       "searchboxAsYouType", "omniboxSearch", "omniboxAnalytics",
                                       "omniboxFromLink", "omniboxField", "searchFromLink"}
    Colleague Searches =
    CALCULATE (
            COUNT('Colleague Events'[SEARCH_ID]), ALLEXCEPT('Colleague Events', 'Colleague Events'[CAUSE2]), 'Colleague Events'[IsDesiredCause] = TRUE()
    )
    This gave the correct output

     

    Best Regards

    Saud Ansari

    If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!

DataInsights's avatar
DataInsights
Super User
2 years ago

saud968,

 

Try this calculated column. The ALL calculate modifier is necessary to clear the filter context, and then apply the desired filter.

 

S =
CALCULATE (
    COUNT ( 'Colleague Events'[SEARCH_ID] ),
    ALL ( 'Colleague Events' ),
    'Colleague Events'[CAUSE2]
        IN {
            "didyoumeanAutomatic",
            "didyoumeanClick",
            "searchboxSubmit",
            "searchboxAsYouType",
            "omniboxSearch",
            "omniboxAnalytics",
            "omniboxFromLink",
            "omniboxField",
            "searchFromLink"
        }
)
  • saud968's avatar
    saud968
    Memorable Member
    2 years ago

    I tried unfortunately still getting the incorrect output

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago
      S =
CALCULATE (
    COUNT ( 'Colleague Events'[SEARCH_ID] ),
    FILTER (
        'Colleague Events',
        'Colleague Events'[Colleague Name]
            = EARLIER ( 'Colleague Events'[Colleague Name] )
            && 'Colleague Events'[CAUSE2]
            IN {
                "didyoumeanAutomatic",
                "didyoumeanClick",
                "searchboxSubmit",
                "searchboxAsYouType",
                "omniboxSearch",
                "omniboxAnalytics",
                "omniboxFromLink",
                "omniboxField",
                "searchFromLink"
            }
    )
)

      If the following information cannot meet your requirement, can you provide some sample output you want?

       

      Best Regards!

      Yolo Zhu

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

      • saud968's avatar
        saud968
        Memorable Member
        2 years ago

        The "Colleague Name" is from another column. However, I was able to resolve the issue by separating the filter. 


        IsDesiredCause =
            'Colleague Events'[CAUSE2] IN {"didyoumeanAutomatic", "didyoumeanClick", "searchboxSubmit",
                                           "searchboxAsYouType", "omniboxSearch", "omniboxAnalytics",
                                           "omniboxFromLink", "omniboxField", "searchFromLink"}
        Colleague Searches =
        CALCULATE (
                COUNT('Colleague Events'[SEARCH_ID]), ALLEXCEPT('Colleague Events', 'Colleague Events'[CAUSE2]), 'Colleague Events'[IsDesiredCause] = TRUE()
        )
        This gave the correct output

         

        Best Regards

        Saud Ansari

        If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!