Forum Discussion
Help with measure
Hi reemadsouza
Thanks for the additions, I can now fully understand what you are trying to do.
But since your second measure uses a DAX formula that involves multiple tables, and we don't know what your structure of those tables and the relationships between them are, it's hard for us to find the cause of the problem and then advise you.Try constructing a new Matrix visual using the fields in the second DAX formula('1 - Company'[Company Name], '3 - Geography'[Geography Name]), then put that measure into the Values of the Matrix visual and see if that works.
If not works, please provide some dummy data that maintains the same data structure and tell us the relationship between the tables.
Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi reemadsouza
May I ask what the problem you are experiencing is? It doesn't seem to be mentioned in your case description.
Please describe the problem you are experiencing and what you expect the results to be. Please provide some dummy sample data if possible.
How to Get Your Question Answered Quickly - Microsoft Fabric Community
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hi Anonymous
I aplogize my post was not that clear. I ahve edited original post to add my query at the end.
Please post some sample data or a sample pbi file.
Hi reemadsouza
Thanks for the additions, I can now fully understand what you are trying to do.
But since your second measure uses a DAX formula that involves multiple tables, and we don't know what your structure of those tables and the relationships between them are, it's hard for us to find the cause of the problem and then advise you.Try constructing a new Matrix visual using the fields in the second DAX formula('1 - Company'[Company Name], '3 - Geography'[Geography Name]), then put that measure into the Values of the Matrix visual and see if that works.
If not works, please provide some dummy data that maintains the same data structure and tell us the relationship between the tables.
Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
