Sales in percentage

[azaterol]

Hello all,

I have a matrix of each main product group. If you click on the main product group, the matrix will open and the items will pop up. 
Already there is the quantity and the sales. 

Now I want create a measure which calculate the sales in percentage of the total sales. 

Have you any ideas?

Thank you all for your answers

--

azaterol

[SpartaBI]

@azaterol check out this pattern and adjust it to your model:
https://www.daxpatterns.com/hierarchies/

Showcase Report – Contoso By SpartaBI

     

[SpartaBI · Accepted solution]

@azaterol I adjusted the code to your model:

% Parent 2 = 
VAR Numerator = SUM('Table'[Sales])
VAR Denominator =
    SWITCH (
        TRUE(),
        ISINSCOPE ( 'Table'[Items + number] ), CALCULATE ( SUM('Table'[Sales]), ALLSELECTED('Table'), VALUES('Table'[Main product group]) ),
        ISINSCOPE ( 'Table'[Main product group] ), CALCULATE ( SUM('Table'[Sales]), ALLSELECTED('Table')),
        Numerator
    )
VAR Result =
    DIVIDE (
        Numerator,
        Denominator
    )
RETURN
    Result

Showcase Report – Contoso By SpartaBI

     

[Anonymous]

Add again your sales measure the sales field and click fiel on visualisation pane

and show as percentage of taotal and it should work