Forum Discussion

Bokazoit's avatar
Bokazoit
Icon for Post Prodigy rankPost Prodigy
3 years ago
Solved

GT measure show wrong result when sorting by another column???

This measure works like a charm:

 

GT Brugertype = DIVIDE (
           [Antal unikke respondenter],
        
        CALCULATE ( [Antal unikke respondenter],  ALLSELECTED(DimBrugertype[BrugertypeGruppe]))
)

 

until I sort [BrugertypeGruppe] by another column

 

I created a [BrugertypeGrpOrder] column with numbers from 1 to 13 and as soon as I use the function sort BrugertypeGruppe by another column BrugertypeGrpOrder it shows 100% all over???

 

This is the correct result:

This is when I choose to sort by the sort column:

Everything the same but the GT is not working?

Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    I think, sort by column also can influence the measure.

    Please try something like below whether it suits your requirement.

     

    GT Brugertype =
DIVIDE (
    [Antal unikke respondenter],
    CALCULATE (
        [Antal unikke respondenter],
        ALLSELECTED (
            DimBrugertype[BrugertypeGruppe],
            DimBrugertype[BrugertypeGrpOrder]
        )
    )
)

2 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    3 years ago

    Hi,

    I think, sort by column also can influence the measure.

    Please try something like below whether it suits your requirement.

     

    GT Brugertype =
DIVIDE (
    [Antal unikke respondenter],
    CALCULATE (
        [Antal unikke respondenter],
        ALLSELECTED (
            DimBrugertype[BrugertypeGruppe],
            DimBrugertype[BrugertypeGrpOrder]
        )
    )
)