Need Help with DAX Formula for ponderation measure

[MSch]

Hello,
I am currently stuck with this problem :

My set of data is a 'table1' such as :

[Name]	[Quantity]	[Price]
Name 1	Quantity 1	Price 1
Name 2	Quantity 2	Price 2

I created a Measure such as : 

Revenue = SUMX('table1','table1'[Price] * [Quantity] )

Now i want to create a table like this :

[Name]	[Revenue]	[Ponderation]
Name 1	Revenue 1	"Revenue1/Total Revenue"
Name 2	Revenue 2	"Revenue2/Total Revenue"

*the bold formula is to show you what i want in the values.

Well i have try to create another Measure that is equal to the ponderation of the line revenue / Total of all revenues of the column (showed as a %), that is where i am stuck, i have tryed this  :

Ponderation = sumx(
                                    SUMMARIZE( 'Table1', 'Table1'[Name] , "Revenue" , [Revenue] ) ,  [Revenue] )
                                    /

                                    CALCULATE(
                                                         sumx( SUMMARIZE( 'Table1', 'Table1'[Name],"Revenue",[Revenue]) , [Revenue] ) ,

                                                         ALLSELECTED('Table1'[Name])
                                  )

The result i have with this formula is :
100%
for every line and i can not find a solution to show the right result, can someone please light my candle?

Thanks in advance,

[mahoneypat]

If you have other columns in that visual, include those in the All( ) too.

Pat

[MSch]

Well after creating a new table with only 2 columns : [name] and [ponderation] the formula works, the problem is that in my dashboard table i have other columns which are calculated measure such as "revenue". And i can not precise them as arguments of ALL() function, so i am still stuck with my problem 😕

[mahoneypat]

Not stuck.  Just use ALL(Table) to remove all the filters from that table.  Or ALLSELECTED(Table) if you still want it to honor slicers on your report page.

Pat

[mahoneypat]

Please try a measure like this

Pct Revenue = DIVIDE([Revenue], CALCULATE([Revenue], ALL(Table[Name])))

Regards,

Pat

[MSch · Accepted solution]

Hello Pat,
Thanks for you reply,
After inputing your solution the result of the measure still show 100% for each line like in the proposed formula, well i also see that if i just input the denominator part of your formula it returns the same as Revenue measure for each line instead of showing in every line the total of revenue. maybe the problem is elsewhere and i cannot find it ?