Forum Discussion

ania_roh's avatar
ania_roh
Icon for Helper III rankHelper III
3 years ago

problem with Dax measure

Hello, I need some help in building my measure because I can´t find a way. I would be very grateful if you could help me. So, I have three columns (in the same table): column of localization_desti...
"Need Help"
Mahesh0016's avatar
Mahesh0016
Icon for Super User rankSuper User
3 years ago

ania_roh Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

  • ania_roh's avatar
    ania_roh
    Icon for Helper III rankHelper III
    3 years ago

    Yes, Mahesh0016, thank you.
    I created powerbi sample but I don´t find a way to attach it here.
    The table would be like that : (localizacion_destino, localización_destino_original, value)

     

    111111111
    234311112
    234523453
    764234564
    345634565
    111123436
    234311117
    764276428
    111123459
    7642458210

     

    The measure  X would be like that: 

    The visualization is like that: 

    Now I need calculate Y (the next column in the visualization) and I don´t know how. 
    For this example, for ID_destino = 1111, Y should give 15: 

    Thank you a lot

     

    • Mahesh0016's avatar
      Mahesh0016
      Icon for Super User rankSuper User
      3 years ago

      ania_roh 

      Y =
      SUMX (
          FILTER (
              localizationTable,
              localizationTable[localizacion_destino] = 1111
                  && localizationTable[localización_destino_original] = 1111
          ),
          localizationTable[value]
      )

      ****************************************************************************************

      _Y =
      SUMX (
          FILTER (
              localizationTable,
              localizationTable[localizacion_destino] = 1111
          ),
          localizationTable[value]
      )

       

       

      ania_roh  If this post helps, please consider accept as solution to help other members find it more quickly and Appreciate your Kudos.

      • ania_roh's avatar
        ania_roh
        Icon for Helper III rankHelper III
        3 years ago

        Yes Mahesh0016 but I want to have it for all rows of that visualizations. 

        Not only for 1111 (I put it to give an example). 

    • FreemanZ's avatar
      FreemanZ
      Icon for Super User rankSuper User
      3 years ago

      hi ania_roh 

      Not sure if i fully get your, try to write the measure like this:

       

      Y = 
VAR _dest = MAX(TableName[DestOrig])
RETURN
SUMX(
    FILTER(
        ALL(TableName), 
        TableName[Dest] = _dest
            &&TableName[DestOrig] <> _dest
    ),
    TableName[Value]
)

       

       

      i tried and it worked like this:

       

       

      • ania_roh's avatar
        ania_roh
        Icon for Helper III rankHelper III
        3 years ago

        Ohhh I can´t believe it! Freeman 

        Thank you a lot

        What if I want it to responde to other fields of the table? Like date and section, for example? 

        Thank you