Total measure need a sum, not calculated

[andreasalleslev]

Halo anybody

I have af problem with a the Total on af measure - I hope some day Powerbi come with af button to select wha way the total have to be calculatede. but for now i hope somone can help me.

The red have to be a sum of row og collunms - not 88021 * 50,25

The meausre is simple: just miltiple 2 measures.

Here is the measures:

1 measure:

beregnet antal på pladsen = [Hvad hvis2] * [Belastnings %]

2 measure:

Hvad hvis2 =

var Memba = SUMX(VALUES('Armbåndtyper'[Armbåndstype]),

    IF('Armbåndtyper'[Armbåndstype] = "Endags", 0,

    if('Armbåndtyper'[Armbåndstype] = "Partout", 'Memba (alle)'[Værdien Memba (alle)], 0

    )

    )

 ) + [Aktive armbaand]

var Guest = SUMX(VALUES('Armbåndtyper'[Armbåndstype]),

        IF('Armbåndtyper'[Armbåndstype] = "Endags", 'Endags Guest'[Værdien Endags Guest],

            IF('Armbåndtyper'[Armbåndstype] = "Partout", 'Partout Guest'[Værdien Partout Guest], 0

            )

        )

) + [Aktive armbaand]        

var Shop = SUMX(VALUES('Armbåndtyper'[Armbåndstype]),

        IF('Armbåndtyper'[Armbåndstype] = "Endags", 'Endags Shop'[Værdien Endags Shop],

            IF('Armbåndtyper'[Armbåndstype] = "Partout", 'Partout Shop'[Værdien Partout Shop], 0

            )

        )

) + [Aktive armbaand]

 var endags = 'Endags Shop'[Værdien Endags Shop] + 'Endags Guest'[Værdien Endags Guest] + [Aktive armbaand]

 var partout = 'Partout Guest'[Værdien Partout Guest] + 'Partout Shop'[Værdien Partout Shop] + 'Memba (alle)'[Værdien Memba (alle)] + [Aktive armbaand]

 return IF(SELECTEDVALUE(TICKETS[System]) = "Memba", Memba,

            IF(SELECTEDVALUE(TICKETS[System]) = "Guest", Guest,

                IF(SELECTEDVALUE(TICKETS[System]) = "Venuemanager", Shop,

                    IF(SELECTEDVALUE('Armbåndtyper'[Armbåndstype]) = "Endags", endags,

                        IF(SELECTEDVALUE('Armbåndtyper'[Armbåndstype]) = "Partout", partout, partout+'Endags Shop'[Værdien Endags Shop]+'Endags Guest'[Værdien Endags Guest])

                )

            )

        )

    )

3 measure:

Belastnings % = DIVIDE([Antal på pladsen], [Aktive armbaand])

       

Hope someone can help me.

Best regards Andreas

[Greg_Deckler · Accepted solution]

@andreasalleslev Seems like the fourth one of these today at least.

First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Also: https://youtu.be/uXRriTN0cfY

And: https://youtu.be/n4TYhF2ARe8

[Greg_Deckler · Accepted solution]

@andreasalleslev Seems like the fourth one of these today at least.

First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Also: https://youtu.be/uXRriTN0cfY

And: https://youtu.be/n4TYhF2ARe8

[andreasalleslev · Accepted solution]

Thanks for this👍 I have now created af measure for every column, and a measure to sum it. That's work