problem with Dax measure

Question

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_destino_original, column of localization_destino and number:And now, I need to build a measure which would have two parts ( one of the localization_destino and the other localization_destino_original) but we would use it in visualization filtred only by localization_destino_original, like that:Now, the measure would have two parts: Let´s say X and Y.Measure = X + YSo the X would be the like that (and it works):X= SUMX(&nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; Table,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Table[LOCALIZACION_DESTINO] &lt;&gt; ANALISIS_ALBARAN2[LOCALIZACION_DESTINO_ORIGINAL]),Number))&nbsp;How can I calculate my Y, if I want to say it all around? &nbsp;I will explain it with an example:&nbsp;&nbsp;I would be very appreciated if you help me.Thank you a lot.&nbsp;

mahesh0016 · Answer

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

ania_roh · Answer

Yes,&nbsp;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)&nbsp;1111111112343111122345234537642345643456345651111234362343111177642764281111234597642458210&nbsp;The measure&nbsp; X would be like that:&nbsp;The visualization is like that:&nbsp;Now I need calculate Y (the next column in the visualization) and I don´t know how.&nbsp;For this example, for ID_destino = 1111, Y should give 15:&nbsp;Thank you a lot&nbsp;

mahesh0016 · Answer

ania_roh&nbsp;Y = SUMX (&nbsp; &nbsp; FILTER (&nbsp; &nbsp; &nbsp; &nbsp; localizationTable,&nbsp; &nbsp; &nbsp; &nbsp; localizationTable[localizacion_destino] = 1111&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; localizationTable[localización_destino_original] = 1111&nbsp; &nbsp; ),&nbsp; &nbsp; localizationTable[value])****************************************************************************************_Y = SUMX (&nbsp; &nbsp; FILTER (&nbsp; &nbsp; &nbsp; &nbsp; localizationTable,&nbsp; &nbsp; &nbsp; &nbsp; localizationTable[localizacion_destino] = 1111&nbsp; &nbsp; ),&nbsp; &nbsp; localizationTable[value])&nbsp;&nbsp;ania_roh&nbsp;&nbsp;If this post helps, please consider accept as solution to help other members find it more quickly and Appreciate your Kudos.

ania_roh · Answer

Yes&nbsp;Mahesh0016&nbsp;but I want to have it for all rows of that visualizations.&nbsp;Not only for 1111 (I put it to give an example).&nbsp;

freemanz · Answer

hi&nbsp;ania_roh&nbsp;Not sure if i fully get your, try to write the measure like this:&nbsp;Y = 
VAR _dest = MAX(TableName[DestOrig])
RETURN
SUMX(
    FILTER(
        ALL(TableName), 
        TableName[Dest] = _dest
            &amp;&amp;TableName[DestOrig] &lt;&gt; _dest
    ),
    TableName[Value]
)&nbsp;&nbsp;i tried and it worked like this:&nbsp;&nbsp;

Forum Discussion

problem with Dax measure

10 Replies

Related content

Measure formula problem

Dax measure for below problem

Logic problem?

Measure problem (problem with ALL)

Slider problems

1111	1111	1
2343	1111	2
2345	2345	3
7642	3456	4
3456	3456	5
1111	2343	6
2343	1111	7
7642	7642	8
1111	2345	9
7642	4582	10