similer function in DAX for Intersect in Spotfire

[Anonymous]

i am trying to migrate Intersect function in Spotfire to DAX in Power BI. 

Spotfire Expression - Column_Name = SUM([Value]) OVER(INTERSECT([Company Name],[Flag],[Name]))

DAX Expression i am writing - 

Column_Name = CALCULATE(SUM(Table[Value]),ALLEXCEPT(Table[Company Name],Table[Flag],Table[Name])) --But this is not resulting as expected.

Please help 

[Greg_Deckler]

For those of us unfamiliar with Spotfire, what does INTERSECT in Spotfire do exactly?

There is an INTERSECT function in DAX. Whether it is the same concept or not to Spotfire I have no idea: https://docs.microsoft.com/en-us/dax/intersect-function-dax

[Anonymous]

Intersect Defination in Spotfire -

Returns the intersected rows from nodes in different hierarchies. See also AllPrevious and All.

Example of a custom expression:

Intersect(Parent([Axis.X]), All([Axis.Color]), Parent([Axis.Rows]), ...)

Example of a calculated column:

Sum([Sales]) OVER Intersect([Category], AllPrevious([Date]))

Sorry intersect function in DAX is different from intersect in Spotfire

[amitchandak]

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

[Anonymous]

Please convert provided spotfire expression into DAX

[Greg_Deckler]

@Anonymous That is very hard to do when you don't know Spotfire language because this is a Power BI board and we all do not know every possible language that exists. See previous reply where I ask to explain what INTERSECT does in Spotfire and point you to the INTERSECT function in DAX.