Highest Count Group

[Anonymous]

Hi all,

    I am in need of calculating and displaying the Highest Count Group in a Card Visual.

Note: Sample PBIX is given below,

Sample PBIX

1. What I have done so far -

 I created a DAX to calculate the Maximum of Reason for a given Slicer selection.

I used a formula for achieving the above result,

MyMeasure = CONCATENATE("Won Reason ", "(" & MAXX(VALUES('Table'[Reason]),CALCULATE(COUNT('Table'[Reason]))) & " / " & COUNTROWS('Table') & ")" )

2. What I need further?

Now, I wanted to count and display the highest count group by Won Reason. Please refer the below screenshot to get more idea, How can I achieve this? Please help on this.

In that 4 --> 3 are due to Quality and 1 is due to price. Likewise, how can I get the results.

Many Thanks,

Praveen

[Zubair_Muhammad · Accepted solution]

Hi @Anonymous 

Try this measure in a card visual

Measure =
CONCATENATEX (
    TOPN (
        1,
        SUMMARIZE (
            'Table',
            [Reason],
            'Table'[Detailed],
            "Won Reason", COUNT ( 'Table'[Reason] )
        ),
        CALCULATE (
            MAXX ( VALUES ( 'Table'[Reason] ), CALCULATE ( COUNT ( 'Table'[Reason] ) ) ),
            ALLEXCEPT ( 'Table', 'Table'[Reason] )
        ), DESC
    ),
    [Won Reason] & " - " & [Detailed],
    UNICHAR ( 10 ),
    [Won Reason], DESC
)

[Zubair_Muhammad · Accepted solution]

Hi @Anonymous 

Try this measure in a card visual

Measure =
CONCATENATEX (
    TOPN (
        1,
        SUMMARIZE (
            'Table',
            [Reason],
            'Table'[Detailed],
            "Won Reason", COUNT ( 'Table'[Reason] )
        ),
        CALCULATE (
            MAXX ( VALUES ( 'Table'[Reason] ), CALCULATE ( COUNT ( 'Table'[Reason] ) ) ),
            ALLEXCEPT ( 'Table', 'Table'[Reason] )
        ), DESC
    ),
    [Won Reason] & " - " & [Detailed],
    UNICHAR ( 10 ),
    [Won Reason], DESC
)

[Zubair_Muhammad · Accepted solution]

@Anonymous 

It works with sample data 🙂 as a card visual

[Anonymous]

Awesome Thank you very much for your prompt solution.

Hearty Thanks again,

Praveen.