Medida para una tarjeta.

[esosa]

Buen día estimada comunidad, quisiera solicitar su valiosa ayuda. 

Cuento con una tabla que me muestra el monitoreo que se hace por medio de una aplicación a los computadores, dentro de esta tabla cuento con una columna que se llama Escala de uso, la cual me indica 4 niveles:

Necesito una medida que me arroje, no la cantidad  numérica del más alto, si no el texto del que mas se repite para incluirlo en una tarjeta o visualización, 

Resultado esperado segun ejemplo, Una Tarjeta con la esca mas alta  ,

 Visualización Tarjeta =  > 8 Horas

[tackytechtom · Accepted solution]

Hi @esosa ,

I used google translate to try to understand what you are after. I believe you would like to find out the value in the column escala de uso which appears the most.

Here a possible solution:

Here the measure in DAX:

MeasureCountEscalaDeUno = 
FIRSTNONBLANK (
    TOPN (
        1, 
        VALUES ( Table[Escala de uno] ), 
        RANKX ( ALL ( Table[Escala de uno] ), COUNT ( [Escala de uno] ),,ASC)
    ), 
    1 
)

 I took the formular from here:

Solved: How to obtain the most common value from a column ... - Microsoft Power BI Community

Here iis even more to read:

Alternative use of FIRSTNONBLANK and LASTNONBLANK - SQLBI

Let me know if this solved your issue 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[PaulDBrown · Accepted solution]

Prueba:

Escala más alta= 
    CONCATENATEX (
        TOPN (
            1,
            ADDCOLUMNS (
                VALUES ( 'Table'[Escala de uso] ),
                "Veces", CALCULATE ( COUNTROWS ( 'Table' ) )
            ),
            [Veces]
        ),
        'Table'[Escala de uso],
        ", "
    )

[tackytechtom · Accepted solution]

Hi @esosa ,

I used google translate to try to understand what you are after. I believe you would like to find out the value in the column escala de uso which appears the most.

Here a possible solution:

Here the measure in DAX:

MeasureCountEscalaDeUno = 
FIRSTNONBLANK (
    TOPN (
        1, 
        VALUES ( Table[Escala de uno] ), 
        RANKX ( ALL ( Table[Escala de uno] ), COUNT ( [Escala de uno] ),,ASC)
    ), 
    1 
)

 I took the formular from here:

Solved: How to obtain the most common value from a column ... - Microsoft Power BI Community

Here iis even more to read:

Alternative use of FIRSTNONBLANK and LASTNONBLANK - SQLBI

Let me know if this solved your issue 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/