% Sales and grand TOTAL

[giuliapiazza94]

Hi guys,

I have a table like this

and I'd like a % value on grand total like this

But if I filter customer (only A and C) I'd like this

Can you help me please? 😊

[Samarth_18]

Hi @giuliapiazza94 ,

Create two measure like below:-

Sales_ = 
SUMX (
    SUMMARIZE ( Sales_data, Sales_data[customer], "sum", [Sales_Total] ),
    [sum]
)

Sales_Total = 
VAR maxevery =
    CALCULATE (
        sum ( 'Sales_data'[sales] ),
        FILTER ( ALL ( 'Sales_data' ), 'Sales_data'[customer] = MAX ( 'Sales_data'[customer] ) )
    )
VAR total_sum =
    calculate(SUM ( 'Sales_data'[sales] ),ALL(Sales_data))
RETURN
 DIVIDE ( maxevery, total_sum )

Now use customer column and sales_ measure in a table visual

Thanks,

Samarth

[giuliapiazza94 · Accepted solution]

Hi, thank you so much but I have found a easier fomula dax.

Sales % = DIVIDE (SUM(sales), calculate( SUM(sales), ALLSELECTED ('Table customers' (customer))) and work very well 😀

[Samarth_18]

@giuliapiazza94 , Just check if its working correctly when you select value from filter. 🙂

[giuliapiazza94]

it works if I filter customer and the other tables too (like calendar) 🙂