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"
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

 

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 

     

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

      hi ania_roh 

      that was something never mentioned, try like

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

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

        FreemanZ no, it doesn´t work 😞