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

 

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).