MATRIX VISUAL

[sarjensystems1]

Hii

i am using the matrix visual and i have the requirement like to display the qty only when we expand to the next level and display the amount as it is ...

i have used the measure=

IF(HASONEVALUE(Table1[Plant]),SUM(Table1[qty]),BLANK())

it has worked when there are multiple plants in the division but when there is single plant in the division it has not worked..

is there any way to do this

[v-joesh-msft · Accepted solution]

Hi @sarjensystems1 ,

You can try the following measure:

Measure 2 = IF(ISINSCOPE('Table'[Plant]),SUM('Table'[qty]),BLANK())

Results are as follows:

Best Regards,

Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.