Hi,
My model is based on the structure below -with the fact table being the link between the peoples and country table.
I am trying to count the number of unique People, which i have accomplished using the countrows statement. =countrows((DISTINCT(People[Name])))
My problem arises when the I try to analyse the number of unique people by Country_Name - The total number of records appear for each person and the formula does not split the total.
Is there a way for the calculated field to work across multiple tables?
<TBODY>
</TBODY>
Many Thanks
My model is based on the structure below -with the fact table being the link between the peoples and country table.
I am trying to count the number of unique People, which i have accomplished using the countrows statement. =countrows((DISTINCT(People[Name])))
My problem arises when the I try to analyse the number of unique people by Country_Name - The total number of records appear for each person and the formula does not split the total.
Is there a way for the calculated field to work across multiple tables?
People</SPAN> | Fact</SPAN> | Country</SPAN> | ||
ID</SPAN> | Sales</SPAN> | ID </SPAN> | ||
Name</SPAN> | Revenue</SPAN> | Name</SPAN> | ||
People</SPAN> | ||||
Country</SPAN> |
<TBODY>
</TBODY>
Many Thanks