Make Visual With Hirarcy table

Question

Hi,my boss told me to make visual data with a visual matrix on power bifor data like what I have screen shot and what my boss wants is to make visuals like those on paper.I've tried to made it and the results like thisHe wants Status 3 and 1 can do hirarcy and the rest of it cannot do that.How do I make the visuals on the matrix the way my boss wants?any suggestion?&nbsp;BR,AdminPBI&nbsp;&nbsp;&nbsp;&nbsp;

v-eachen-msft · Accepted Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
You could do it with the following measure.
value measure =
IF (
    SELECTEDVALUE ( 'Table'[Column1] ) = "A",
    SUM ( 'Table'[Value] ),
    IF ( NOT ( ISINSCOPE ( 'Table'[Column2] ) ), SUM ( 'Table'[Value] ) )
)
Here is the result.

Here is my test file for your reference.
&nbsp;

Forum Discussion

Make Visual With Hirarcy table

2 Replies

Related content

export from visual table

Table visual error

Table Visual not Matching Calculated Visual

Table Visual Sorting

PowerBI - Matrix table, hide values used only for a visual calculation