To achieve a dynamic tile which is trying to give me a dynamic status of the process which has maxim

[Anonymous]

Hi PBIXER,

I am trying to achieve a dynamic tile which is trying to give me a dynamic status of the process which has maximum error in the production something like below snapshot,

in the above case Finishing Issue has highest number 795 in all the issuess.

in the dynamic tile we want to display Finishing Issue.

This is related Quality check concept.

An swift reply will help,

Thank You in advance.

[OwenAuger · Accepted solution]

Hi @Anonymous 

You can certainly write a measure that returns the Issue with the highest error value.

The basic structure of the measure is:

Dynamic title =
FIRSTNONBLANK (
    TOPN (
        1,
        VALUES ( YourTable[Issue] ),
        [Error Sum]
    ),
    0
)

Note that you would have to write a measure [Error Sum] for this to work.

Ties are arbitrarily broken with FIRSTNONBLANK.

This pattern was taken from this article:

https://www.sqlbi.com/articles/alternative-use-of-firstnonblank-and-lastnonblank/

Does this work?

Regards
Owen

[OwenAuger]

@Anonymous 

Just following up, if you are wanting to show the error value as well, you could write something like either of these:

Dynamic title =
SELECTCOLUMNS (
    FIRSTNONBLANK (
        TOPN (
            1,
            VALUES ( YourTable[Issue] ),
            [Error Sum]
        ),
        0
    ),
    "@Dynamic Title",
        YourTable[Issue] & ": " & [Error Sum]
)

Dynamic title =
VAR IssueError =
    ADDCOLUMNS (
        VALUES ( YourTable[Issue] ),
        "@Error", [Error Sum]
    )
VAR TopRow =
    TOPN (
        1,
        IssueError,
        [@Error]
    )
RETURN
    MINX (
        TopRow,
        YourTable[Issue] & ": " & [@Error]
    )

Regards,

Owen

[PattemManohar]

@Anonymous  To make it very clear, you are looking for a dynamic tile (to pin in a dashboard) that will display the category/status (a text field) based on the highest number of errors compared with all other categories/statuses.

Is that correct ? If yes, then you need to have a DAX Measure that will display that text field on the card and pin that visual to the dashboard. That will be dynamic based on the report refresh schedule.