Sum to higher level in hierarchy - unexpected results
I had to port a solution from SSAS multidimensional to PowerBI. Unfortunately, it involves many to many relations and parent-child hierarchies:).
I don't get correct sum for the higher level for a measure (first clumn in example below), which shows only positive amounts.
First column - actually a measure is calculated from second column (also a measure) : IF ([ZnesekIzkazPredznakSum] > 0;[ZnesekIzkazPredznakSum];BLANK()) On the leaf level things are ok, but on the parent level, the negative value is included.
Thanks for reply, I'm new to tabular and DAX,please bear with me 🙂
In my case I have added a series of measures, because ob M2M relationship and attributes in the intermediate table which affect calculation in fact table. So I came to final calculation by steps. But only at the final step I want to check for negative amounts. Using your proposed solution would filter underlying negative rows ...
I tried to convert this last measure (before checking for negative) to column, but I get an out of memory error.