Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 based on the frequency of the result,
E.g.
FP Division = A
P Division = A
G Division = A
Any help on this!
Thanks
Hi @Peckle,
Just trying to understand your question. Do you need to see how many times a Division received A or AA in Audit?
Seeminlgy you need the most recurring audit for each division
Try this MEASURE
Measure = VAR MaxCount = MAXX ( VALUES ( Table1[Audit] ), CALCULATE ( COUNT ( Table1[Audit] ) ) ) RETURN CONCATENATEX ( FILTER ( VALUES ( Table1[Audit] ), CALCULATE ( COUNT ( Table1[Audit] ) ) = MaxCount ), [Audit], ", " )
Thanks, this worked for me (after trying many other approaches!)
That's right. I want to display the most recurring audit for each division
Thanks I'll try this!
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.
Thanks,
Xi Jin.
Thanks for reaching out!
Unfortunately, I couldn't get the second part of the syntax to return a value.
Thanks
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
77 | |
69 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |