topic Re: Function sign in DAX Commands and Tips

Function sign

Olenard — Wed, 14 Oct 2020 18:47:02 GMT

Dear power Bi community

i am trying to use the command sign. But the results is strange. Please see below :

I excpected the results to be -1 on negative lines.

Thank you all

Re: Function sign

AlB — Wed, 14 Oct 2020 19:37:41 GMT

Hi Olenard

You are applying the SIGN() function to the SUM of all the elements in the column. Try this instead:

CA Type Line = SIGN( Sales[Net Sales] )

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers

Re: Function sign

Olenard — Thu, 15 Oct 2020 06:38:16 GMT

Hi,

but Am I not in a row contexte. Using only Sales(net sales) this does not work. The Dax formula expects a measure

Re: Function sign

AlB — Thu, 15 Oct 2020 06:45:08 GMT

Olenard

Then you need to explain what you need better. You show a calculated column and you talk about wanting the result for each row, so this is confusing/contradictory information if you do not have a row context. IS it a measure what you need? If so, what is the measure supposed to do exactly?

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers

Re: Function sign

Olenard — Tue, 20 Oct 2020 20:50:46 GMT

AlB

Thank you for your reply.

My sentence was not clear.

I am in a row context. Since I am in a row context I expected the formula to take the sign of the sales column.

Regarding the measure, the thing was that the function sign does not accept column as a reference, only measure.

how do i indicate in this column that I only want the sign of the row.

Re: Function sign

AlB — Wed, 21 Oct 2020 05:26:13 GMT

Olenard

Sorry, I still do not understand what the problem/question is.

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers

Re: Function sign

Anonymous — Wed, 21 Oct 2020 10:14:31 GMT

Olenard

If you use SUM(...) when you have a row context, the SUM does not see any row context since it's an aggregator and only works with filter contexts. So, SUM sees ALL ROWS at the same time. Please remove SUM from the formula and it'll then work row by row. Please learn about contexts and how they behave.

By the way, SIGN does NOT need a measure: https://dax.guide/sign/

Re: Function sign

Olenard — Wed, 21 Oct 2020 13:36:32 GMT

Hi Anonymous ,
I think I get it. Should I use Sumx then ?