Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Combine two different DAX measures in one

HI

How we can combine two or more meausres in one DAX

6 Replies

  • Nathaniel_C's avatar
    Nathaniel_C
    Icon for Community Champion rankCommunity Champion

    Hi Anonymous ,

    We need more info.  [Water] = [Count of Hydrogen] + [Count of Oxygen] combines two measures into one.
    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
    Nathaniel

    • Anonymous's avatar
      Anonymous
      Not applicable

      Please find the attached sample data for working, in this report i wish to be have Total Headcount to be filter by City, region month year, and when i select month and any one of other slicer then Visual has to display value accordingly.

       

      I have shared my meaure in which i have shown if there is no value selected then visual should show currant month details (should be this if there is no selection if multiple slicer selection then visual has to display data)

      and then display as per selection.

       

      Hope i clear on my results

       

      Please let me know if you have any query

       

      https://1drv.ms/u/s!Ai3rGPgy20kLwiHBBsBjZXHojmEP?e=hSs8Xz

      • Icey's avatar
        Icey
        Icon for Community Support rankCommunity Support

        Hi Anonymous ,

        In your PBIX file, please select slicer of "City" from Table "City" instead of Table "Columns for filter or Slicer".

         

        Best Regards,
        Icey

         

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

  • Icey's avatar
    Icey
    Icon for Community Support rankCommunity Support

    Hi Anonymous ,

     

    Is this problem sloved?

     

    If it is sloved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

     

    If not, please let me know.

     

    Best Regards
    Icey

    • Anonymous's avatar
      Anonymous
      Not applicable
      sorry i was away from the PC in last few days, will try it today and will let you know.
  • Icey's avatar
    Icey
    Icon for Community Support rankCommunity Support

    Hi Anonymous ,


    Is this problem solved?


    If it is solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.


    If not, please let me know.


    Best Regards
    Icey