Forum Discussion

Peckle's avatar
Peckle
Regular Visitor
8 years ago

Most Frequently Occurring Text / Aggregating String Values

Hi All,    I'm having trouble finding out how I can portray the mode of a text/string value using DAX.   Below is a snippet of my data.   I want to be able to show the Audit result by Division ...
Peckle's avatar
Peckle
Regular Visitor
8 years ago

Zubair_Muhammad

 

That's right. I want to display the most recurring audit for each division

 

Thanks I'll try this! 

v-xjiin-msft's avatar
v-xjiin-msft
Solution Sage
8 years ago

Hi Peckle,

 

Did you resolve your issue? If so, please kindly mark the corresponding reply as an answer. It will benifit others with relevant issues. If not, please feel free to ask. :smileyhappy:

 

Thanks,
Xi Jin.

  • Peckle's avatar
    Peckle
    Regular Visitor
    8 years ago

    Hi v-xjiin-msft

     

    Thanks for reaching out!

     

    Unfortunately, I couldn't get the second part of the syntax to return a value. 

     

    Thanks

     

    • v-xjiin-msft's avatar
      v-xjiin-msft
      Solution Sage
      8 years ago

      Hi Peckle,

       

      => Unfortunately, I couldn't get the second part of the syntax to return a value. 

       

      Did you get any error message? Could you please share us some screenshots about your issue if possible?

       

      Thanks,
      Xi Jin.