Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
Anonymous
Not applicable

Cómo obtener un valor de fila diferente en el informe de matriz

‎08-02-2020 01:07 AM

Hola

Tengo un informe de matriz debajo del formato.

krishnanarra_0-1596355297123.png

Valor 4 - Valor1+Valor2-Valor3

si el valor inicial1 es 0 necesito mostrar el valor anterior4. Intenté usar la búsqueda en si la condición conseguir dependencia circular. Cualquier ayuda lo apreciaría.

Datos

ArtículoFechaValor 1Valor 2Valor 3Inventario de fin de mes
K6071007/01/2020 0:00450302054298
K6071008/01/2020 0:0001045240805
K6071009/01/2020 0:00016621080582
K6071010/01/2020 0:000304414501594
K6071011/01/2020 0:00018105816-4006
K6071012/01/2020 0:0004392800-2361
K6071001/01/2021 0:000414697-283
K6071002/01/2021 0:0001167425742
K6071003/01/2021 0:00011481560-412
K6071004/01/2021 0:0006562050-1394
K6071005/01/2021 0:0007741513-739
K6071006/01/2021 0:000535909-374
K6071007/01/2021 0:000496996-500
K6071008/01/2021 0:0001158841317
K6071009/01/2021 0:0006191688-1069
K6071010/01/2021 0:000382217752047
K6071011/01/2021 0:00016485396-3748
K6071012/01/2021 0:0004792392-1913
K6PS6407/01/2020 0:0091600916
K6PS6408/01/2020 0:000000
K6PS6409/01/2020 0:000000
K6PS6410/01/2020 0:000000
K6PS6411/01/2020 0:000000
K6PS6412/01/2020 0:000000
K6PS6401/01/2021 0:0000178-178
K6PS6402/01/2021 0:000196204-8
K6PS6403/01/2021 0:0002902846
K6PS6404/01/2021 0:000348366-18
K6PS6405/01/2021 0:000376377-1
K6PS6406/01/2021 0:000209226-17
K6PS6407/01/2021 0:000229244-15
K6PS6408/01/2021 0:00032027545
K6PS6409/01/2021 0:000285294-9
K6PS6410/01/2021 0:00040134358
K6PS6411/01/2021 0:000374415-41
K6PS6412/01/2021 0:000210320-110
K6PS9407/01/2020 0:0083100831
K6PS9408/01/2020 0:000000
K6PS9409/01/2020 0:000000
K6PS9410/01/2020 0:00073073
K6PS9411/01/2020 0:00036931554
K6PS9412/01/2020 0:000224335-111
K6PS9401/01/2021 0:00031324766
K6PS9402/01/2021 0:00027225418
K6PS9403/01/2021 0:00039329895
K6PS9404/01/2021 0:000517384133
K6PS9405/01/2021 0:000435574-139
K6PS9406/01/2021 0:000226389-163
K6PS9407/01/2021 0:00032424579
K6PS9408/01/2021 0:00042436064
K6PS9409/01/2021 0:000627340287
K6PS9410/01/2021 0:000593702-109
K6PS9411/01/2021 0:000459489-30
K6PS9412/01/2021 0:0003545-542
Message 1 of 9
242 Views
0
8 REPLIES 8
v-lionel-msft
Community Support
Community Support

‎08-02-2020 07:11 PM

Hola @krishnanarra ,

Por favor, hazlo así.

1. Despotable las tres columnas.

v-lionel-msft_0-1596420427270.png

2. Cree una medida como esta.

Measure = 
VAR v1 = 
CALCULATE( 
    MAX('Sheet1 (2)'[Value]), 
    FILTER( 'Sheet1 (2)', 'Sheet1 (2)'[Attribute] = "Value1")
)
VAR v2 = 
CALCULATE( 
    MAX('Sheet1 (2)'[Value]), 
    FILTER( 'Sheet1 (2)', 'Sheet1 (2)'[Attribute] = "Value2")
)
VAR v3 = 
CALCULATE( 
    MAX('Sheet1 (2)'[Value]), 
    FILTER( 'Sheet1 (2)', 'Sheet1 (2)'[Attribute] = "Value3")
)
VAR v4_1 = v1 + v2 - v3
VAR v = MAX('Sheet1 (2)'[Value])
RETURN
IF(
    HASONEFILTER( 'Sheet1 (2)'[Attribute] ),
    v,
    IF(
        v1 <>0,
        v4_1,
        CALCULATE(
            MAX('Sheet1 (2)'[Month End Inventory]),
            FILTER(
                ALL('Sheet1 (2)'),
                'Sheet1 (2)'[DATE] < MAX('Sheet1 (2)'[DATE]) && 'Sheet1 (2)'[Item] = MAX('Sheet1 (2)'[Item]) && 'Sheet1 (2)'[Attribute] = MAX('Sheet1 (2)'[Attribute])
            )
        )
    )
)

3. Cambie el nombre de la etiqueta del subtotal de fila.

v-lionel-msft_1-1596420504539.png

v-lionel-msft_2-1596420530287.png

Saludos
Lionel Chen

Si este post ayuda,entonces considere Aceptarlo como la solución para ayudar a los otros miembros a encontrarlo más rápidamente.

How to get different row value in matrix report.pbix
Message 6 of 9
186 Views
0
Anonymous
Not applicable
In response to v-lionel-msft

‎08-03-2020 02:37 AM

Gracias por su respuesta. ¿Cómo puedo colocar el valor 4 en value1 si el valor 1 0 y otra vez v4-v1+v2-v3. Por ejemplo, en los valores de la segunda columna tiene 0 en value1 necesito poner el valor anterior4 4296 en value1 y v4 cálculo se repite como v1+v2-v3

Message 7 of 9
179 Views
0
v-lionel-msft
Community Support
Community Support
In response to Anonymous

‎08-12-2020 02:23 AM

Hola @krishnanarra ,

¿Es esto?

Measure 2 = 
VAR v1 = 
CALCULATE( 
    MAX('Sheet1 (2)'[Value]), 
    FILTER( 'Sheet1 (2)', 'Sheet1 (2)'[Attribute] = "Value1")
)
VAR v2 = 
CALCULATE( 
    MAX('Sheet1 (2)'[Value]), 
    FILTER( 'Sheet1 (2)', 'Sheet1 (2)'[Attribute] = "Value2")
)
VAR v3 = 
CALCULATE( 
    MAX('Sheet1 (2)'[Value]), 
    FILTER( 'Sheet1 (2)', 'Sheet1 (2)'[Attribute] = "Value3")
)

VAR total1 = v1+v2-v3
VAR v1_new= 
CALCULATE(
    MAX('Sheet1 (2)'[Month End Inventory]),
    FILTER( ALL('Sheet1 (2)'), 'Sheet1 (2)'[DATE] < MAX('Sheet1 (2)'[DATE]) && 'Sheet1 (2)'[Item] = MAX('Sheet1 (2)'[Item]) && 'Sheet1 (2)'[Attribute] = MAX('Sheet1 (2)'[Attribute]) )
)

RETURN
IF(
    HASONEFILTER('Sheet1 (2)'[Attribute]),
    MAX('Sheet1 (2)'[Value]),
    IF(
        v1 <> 0,
        total1,
        v1_new+v2-v3
    )
)

v-lionel-msft_0-1597224088657.png

Saludos
Lionel Chen

Si este post ayuda,entonces considere Aceptarlo como la solución para ayudar a los otros miembros a encontrarlo más rápidamente.

How to get different row value in matrix report (2).pbix
Message 8 of 9
175 Views
0
v-lionel-msft
Community Support
Community Support
In response to v-lionel-msft

‎08-26-2020 11:30 PM

Hola @krishnanarra ,

¿Ha resuelto su problema?

Saludos
Lionel Chen

Si este post ayuda,entonces considere Aceptarlo como la solución para ayudar a los otros miembros a encontrarlo más rápidamente.

Message 9 of 9
157 Views
0
simrantuli
Continued Contributor
Continued Contributor

‎08-02-2020 08:41 AM

Hola @krishnanarra,

A continuación encontrará la solución utilizando la columna Calculado.

simrantuli_0-1596382716370.png

simrantuli_1-1596382755553.png

Espero que esto sea lo que querías lograr.

saludos

Simran Tuli

Message 5 of 9
191 Views
0
Fowmy
Super User
Super User

‎08-02-2020 01:18 AM

@krishnanarra

No está muy claro sobre el requisito y será fácil ayudarle si puede compartir algunos datos de muestra y los resultados esperados. puede pegar sus datos con la respuesta.

________________________

¿He respondido a tu pregunta? Marque este post como una solución, esto ayudará a otros!.

Haga clic en el icono Thumbs-Up a la derecha si le gusta esta respuesta 🙂

YoutubeLinkedin

Did I answer your question? Mark my post as a solution! and hit thumbs up


⭕ Subscribe and learn Power BI from these videos

⚪ Website ⚪ LinkedIn ⚪ PBI User Group

Message 2 of 9
231 Views
0
Anonymous
Not applicable
In response to Fowmy

‎08-02-2020 02:24 AM

Datos

ArtículoFechaValor 1Valor 2Valor 3
K6071007/01/2020 0:0045030205
K6071008/01/2020 0:0001045240
K6071009/01/2020 0:00016621080
K6071010/01/2020 0:00030441450
K6071011/01/2020 0:00018105816
K6071012/01/2020 0:0004392800
K6071001/01/2021 0:000414697
K6071002/01/2021 0:0001167425
K6071003/01/2021 0:00011481560
K6071004/01/2021 0:0006562050
K6071005/01/2021 0:0007741513
K6071006/01/2021 0:000535909
K6071007/01/2021 0:000496996
K6071008/01/2021 0:0001158841
K6071009/01/2021 0:0006191688
K6071010/01/2021 0:00038221775
K6071011/01/2021 0:00016485396
K6071012/01/2021 0:0004792392
K6PS6407/01/2020 0:0091600
K6PS6408/01/2020 0:00000
K6PS6409/01/2020 0:00000
K6PS6410/01/2020 0:00000
K6PS6411/01/2020 0:00000
K6PS6412/01/2020 0:00000
K6PS6401/01/2021 0:0000178
K6PS6402/01/2021 0:000196204
K6PS6403/01/2021 0:000290284
K6PS6404/01/2021 0:000348366
K6PS6405/01/2021 0:000376377
K6PS6406/01/2021 0:000209226
K6PS6407/01/2021 0:000229244
K6PS6408/01/2021 0:000320275
K6PS6409/01/2021 0:000285294
K6PS6410/01/2021 0:000401343
K6PS6411/01/2021 0:000374415
K6PS6412/01/2021 0:000210320

Message 4 of 9
175 Views
0
Anonymous
Not applicable
In response to Fowmy

‎08-02-2020 02:13 AM

Datos

ArtículoFechaValor 1Valor 2Valor 3
K6071007/01/2020 0:0045030205
K6071008/01/2020 0:0001045240
K6071009/01/2020 0:00016621080
K6071010/01/2020 0:00030441450
K6071011/01/2020 0:00018105816
K6071012/01/2020 0:0004392800
K6071001/01/2021 0:000414697
K6071002/01/2021 0:0001167425
K6071003/01/2021 0:00011481560
K6071004/01/2021 0:0006562050
K6071005/01/2021 0:0007741513
K6071006/01/2021 0:000535909
K6071007/01/2021 0:000496996
K6071008/01/2021 0:0001158841
K6071009/01/2021 0:0006191688
K6071010/01/2021 0:00038221775
K6071011/01/2021 0:00016485396
K6071012/01/2021 0:0004792392
K6PS6407/01/2020 0:0091600
K6PS6408/01/2020 0:00000
K6PS6409/01/2020 0:00000
K6PS6410/01/2020 0:00000
K6PS6411/01/2020 0:00000
K6PS6412/01/2020 0:00000
K6PS6401/01/2021 0:0000178
K6PS6402/01/2021 0:000196204
K6PS6403/01/2021 0:000290284
K6PS6404/01/2021 0:000348366
K6PS6405/01/2021 0:000376377
K6PS6406/01/2021 0:000209226
K6PS6407/01/2021 0:000229244
K6PS6408/01/2021 0:000320275
K6PS6409/01/2021 0:000285294
K6PS6410/01/2021 0:000401343
K6PS6411/01/2021 0:000374415
K6PS6412/01/2021 0:000210320

krishnanarra_0-1596359665144.png

para el valor de la columna August1 - valor1 a 4298 que es valor4 de july2020

Message 3 of 9
214 Views
0

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

View All