Most Frequently Occurring Text / Aggregating String Values

[Peckle]

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

[Anonymous]

Hi @Peckle,

Just trying to understand your question. Do you need to see how many times a Division received A or AA in Audit?

[Zubair_Muhammad]

@Peckle

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

[mattlewis]

Thanks, this worked for me (after trying many other approaches!)

[Peckle]

@Zubair_Muhammad

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

Thanks I'll try this! 

[v-xjiin-msft]

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.

[Peckle]

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]

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.