Forum Discussion
Measure Not working on Sankey Chart
Hi N_A_S_H ,
Thanks for your reply. I reviewed a while and found that the cause.
You can observe that it's the gaps caused by issues with the order of your visual fields. The positions of A party and B party are reversed.
Similarly, your matrix has a row B-Party at the top and a column at the bottom with A-Party. Your filter is to show the value when the count of A-Party is greater than 1.
It would be more intuitive if you replaced Grand Total with a filter's metric, as follows:
For each row of the B-Party, the distinctcounting of A-Party with 03004444444 is 1 and will be filtered out. Others greater than 1 will be retained.
At this point I put A-Party in the row and B-Party in the column, as follows:
You can see that, A-Party is assigned to each row, so the distinctcounting of A-Party in each row is 1, which is the filter condition when the distinctcounting of A-Party is greater than 1, all rows will be filtered out.
Summary: This question involves the row context, if you are interested, you can refer to:
Context in DAX Formulas - Microsoft Support
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
