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.
Hi N_A_S_H ,
You should note that your measure is placed as a filter at the visual level.
Then I tested it, and the measure filter was placed in the matrix, and it was also empty.
Please provide more details of your issue.
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.
Hi Anonymous,
Please take a look at the second page of the report for the measure output.
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.