Row level % in Matrix

[Baskar]

Thanks Advaced,

My prob is have to calculate row level percentage in matrix report. 

Table Explain:

Month from - Month master

Product (A,B,C) from - Product Master

Sales from - Sales master 

Question is :

       How to get row level percentage ? using DAX.

Thanks

@Sean @ankitpatira @KHorseman @Seth_C_Bauer

[Vvelarde]

Hi, this was my solution.

My% =
DIVIDE (
    CALCULATE (
        SUM ( Sales[Sales] );
        ALLEXCEPT ( Sales; Sales[Product]; Sales[Month] )
    );
    CALCULATE ( SUM ( Sales[Sales] ); ALLEXCEPT ( Sales; Sales[Product] ) )
)

[Sean]

If your sales data is formatted as in the picture you posted - obviously you need to Unpivot first!

Then just use this measure - you basically need a total for each product which you can get with ALLEXCEPT

EDIT: Overall Total for each Product (Denominator)

Measure =
DIVIDE (
    SUM ( Sales[Sales] ),
    CALCULATE ( SUM ( Sales[Sales] ), ALLEXCEPT ( Sales, Sales[Product] ) ),
    0
)

[Baskar]

Hi @Sean

Which i shown in picture that is not my data.

First 1 is which am getting now in Power BI, Second one is i need.

one more info, Product is from different table.

[Sean]

So how are sales and product connected?

[Baskar · Accepted solution]

Thanks @Sean

I got the solution, i did previously but i forgot it now i got it.

anyhow thanks buddy....

% Cal = Divide(Sum(Sales[Sales]), Calculate(Sum(Sales[Sales]),All(Date[month]))) 

[Sean]

Okay great!

Measure 2 = 
DIVIDE (
    SUM ( Sales[Sales] ),
    CALCULATE ( SUM ( Sales[Sales] ), ALL('Calendar') ),
    0
)

[Baskar]

I have product ID Relationship