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 

       

      • 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]
        )