Use constant value in measure

[Anonymous]

Hello folks,

I have a problem. I am going to try to explain as detailed as possible, but in case questions arise, please do not hesitate to ask.

I have got a visual which consists out of many measures. These measures calculate different collumns in different tables.

The values are dynamic by and I can filter them by different contexts.

I also need the totals. Those are supposed to be used as KPIs.

Screenshots below:

What it looks like at the moment

In the visual it is supposed to show the total of all the lines (being filtered here). Right now it uses the previous total.

Example: 

[NAZ-SOLL] = [GLZ-STUNDEN] * [NAZ-TAGE]

Right now it calculates the sums. It is supposed to calculate the values on its own and THEN sum them up.

Can anyone help?

All the best,

c4ss10p314

[v-chuncz-msft]

@Anonymous 

Take a look at ISINSCOPE as well.

• https://community.powerbi.com/t5/Desktop/Sum-of-values-in-a-measure-with-divide-measure/m-p/296768#M...
• https://community.powerbi.com/t5/Desktop/Hide-matrix-rows-without-affecting-values/m-p/646134#M30968...

[Anonymous]

Thank you very much! I've already solved it by creating the measure as a virtual table, but that would probably work as well

[analist_investi]

I solved it as you say. with the virtual table creating there my constant value. Thank you.

But if I use few values I have to create multiple tables, right?

Any more optimal way?

[Anonymous]

It's apparently fairly simple.

We used SUMMARIZE to create a virtual table.

[amitchandak]

@Anonymous ,

For multiplication, we should sum(A*B), if not then sum(A)* Sum(B) need a common context

[NAZ-SOLL] =sumx(summarize(Dim,Dim[Common],"_1", [GLZ-STUNDEN],"_2", [NAZ-TAGE])[_1]*[_2])

Also, refer how to use context: https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970

[Greg_Deckler · Accepted solution]

Not sure I follow, but perhaps: 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