Forum Discussion
Resolver IIMeasure value doesn't appear when fields from other table are added in a non match case
Hi All,
Please help me!!
I have issue like below-
Table 1: I have a table like below , I can see the measure value in the grand total but I cannot see the measure value in the row because there are no matching records found for the columns(they appear as blank).
Table 2: If I remove all the columns and keep only the main column the measure value appears.
Model:
Can someone pls explain me this behavior and how can I fix it?
Hi alexa_0028 ,
WIthout any further details is difficult to help you. However looking at the model I can see that you have bidirectional filters turn on between two table this can cause ambiguity in the calculations and the result be incorret.
Try to set the filter of the relationships from bidirectional to single and then use the code from the table C Account on your table visualization then start adding the columns from the other tables and check if the result is has you need.
2 Replies
- MFelix
Super User
Hi alexa_0028 ,
WIthout any further details is difficult to help you. However looking at the model I can see that you have bidirectional filters turn on between two table this can cause ambiguity in the calculations and the result be incorret.
Try to set the filter of the relationships from bidirectional to single and then use the code from the table C Account on your table visualization then start adding the columns from the other tables and check if the result is has you need.
Hi alexa_0028 ,
Does the replies above solve your problem? If it has been solved, please mark the correct reply as the standard answer to help the other members find it more quickly.Thank you very much for your kind cooperation!
If not，Sample data without sensitive information and expected output would help tremendously.
Hope it helps,
Community Support Team _ CaitlynIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
