xViz Performance Flow - Display different values at different hierarchy level

[Snapdrag]

I am facing issue in presenting different values at different hierarchy level in the xViz Performance Flow visual. It add all the values from last hierarchy and show the result at upper level. I have tried using INSCOPE dax measure which is working fine in matrix visual but not working with xViz Performance Flow visual. 

Level 1	Level 2	Level 3	Value
Grow	Out	A	3
Grow	Out	B	4
Grow	Out	C	5
Grow	Out	D	6
Grow	In	E	7
Grow	In	F	8
Grow	In	G	9
Grow	In	H	2

At Level 3 I have to show the value column as it is. At level I will pick the Average for "In" and "Out" and Maximum of "In" and "Out" at Level 1.

[Anonymous]

Hi,@Snapdrag  I am glad to help you.
According to your description, you want to implement the effect shown in the matrix in a custom visual: for each level, show the results of the calculations defined for each level
For level3, display the value values.
For level 2, show the average of the values for level 3 according to the hierarchical classification (3+4+5+6)/4=4.5
(7+8+9+2)/4=6.4
For level1, show the maximum value for level2 according to the hierarchical classification.
Take the maximum value 6.5 out of 4.5 and 6.5.
like this.

I created the measure and as you described, it shows up well in the matrix

As for the custom visual object: xViz Performance Flow, it can only show the set aggregation value for the parent level which has children, but it doesn't support to show the correct result according to the hierarchical judgment logic in the measure.
In fact, I tried to show it as table, and it shows that for the parent level, xViz Performance Flow doesn't show the correct result for the measure, they use the aggregation type that is initially set in the visual.

Therefore, I suggest you contact the visual's production team to see if the visual can automatically display the judgment logic in the measure based on the hierarchical judgment.
You can get more help by visiting the corresponding visual forum.

URL:
Performance Flow - xViz (microsoft.com)
Frequently asked questions (FAQ) | xViz
 Or you can look through visual shops for more custom visual like this to see if there are other visual that support your idea!
Here is the code and data I tested

M_filtered = 
VAR _value2=CALCULATE(AVERAGE('Table'[Value]),FILTER(ALL('Table'),'Table'[Level 2]=MAX('Table'[Level 2])))
VAR _value1=CALCULATE(MAXX('Table',[M_level_2]),FILTER(ALL('Table'),'Table'[Level 1]=MAX('Table'[Level 1]))) 
VAR result= SWITCH(TRUE(),
ISINSCOPE('Table'[Level 3]),MAX('Table'[Value]),
ISINSCOPE('Table'[Level 2]),_value2,
ISINSCOPE('Table'[Level 1]),_value1,
SUM('Table'[Value])
)
RETURN result

search for other visuals

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.