Forum Discussion

JC1989's avatar
JC1989
Frequent Visitor
2 years ago
Solved

Medidas se repiten en visual Matriz

https://drive.google.com/file/d/1u1yXXjy-ovxoQmGOIUDE6vcVAJSSu9nE/view?usp=sharing 

 

Se repiten las columnas para cada categoría. Me ayudan!

  • hello JC1989 

     

    you have two 1CPC1 and 1LETE because you put two measures in Values section. then PBI sees that as two values in one column.

     

    for example in LETE/BON1/ONFF column, as you have two measures in one column but you use 'Operaciones'[SubLOB] = 2 in your measure which only calculates for 1LETE which leads into blank value for 1CPC1 (not calculated).

     

    does CPC have only one value 1CPC1 or it has multiple value? and does LETE/BON1/ONFF have only one value 1LETE or it has multiple value as well?

     

    if CPC and LETE/BON1/ONFF only have one value, then just use one measure (no need to split the measure especially, both measure have almost same formula).

     

    here is an example.

    there is only one value each column since there is only one measure.

    thus you will see other column will have their values since the measure dont use any calculation filter.

    Sum = 
    VAR TotalGeneral =
        CALCULATE(
            SUM('Operaciones'[OPS_VALORIZACION_DOLAR]) * [0TC]
        )
    Return
        DIVIDE(
            TotalGeneral,
            1000000
        )

    However, if you dont want to show them, you can use visual filter.

     

    if you dont want to use visual filter, then you can use slicer with NombreSubLOB as slicer value so your user can choose whichever they want to see.

     

    Lastly, please write your post in english.

     

    Hope this will help.

    Thank you.

  • Irwan Thank you, I found a workaround to resolve the issue. I created a table to store the names of the measures with their respective sublob, and then with a single measure, I make each measure appear in the correct column. Regards.

2 Replies

  • JC1989's avatar
    JC1989
    Frequent Visitor

    Irwan Thank you, I found a workaround to resolve the issue. I created a table to store the names of the measures with their respective sublob, and then with a single measure, I make each measure appear in the correct column. Regards.

  • hello JC1989 

     

    you have two 1CPC1 and 1LETE because you put two measures in Values section. then PBI sees that as two values in one column.

     

    for example in LETE/BON1/ONFF column, as you have two measures in one column but you use 'Operaciones'[SubLOB] = 2 in your measure which only calculates for 1LETE which leads into blank value for 1CPC1 (not calculated).

     

    does CPC have only one value 1CPC1 or it has multiple value? and does LETE/BON1/ONFF have only one value 1LETE or it has multiple value as well?

     

    if CPC and LETE/BON1/ONFF only have one value, then just use one measure (no need to split the measure especially, both measure have almost same formula).

     

    here is an example.

    there is only one value each column since there is only one measure.

    thus you will see other column will have their values since the measure dont use any calculation filter.

    Sum = 
    VAR TotalGeneral =
        CALCULATE(
            SUM('Operaciones'[OPS_VALORIZACION_DOLAR]) * [0TC]
        )
    Return
        DIVIDE(
            TotalGeneral,
            1000000
        )

    However, if you dont want to show them, you can use visual filter.

     

    if you dont want to use visual filter, then you can use slicer with NombreSubLOB as slicer value so your user can choose whichever they want to see.

     

    Lastly, please write your post in english.

     

    Hope this will help.

    Thank you.