I have three tables like above. In this tables, the below relationships exist.
soccermasterdata[RowKey] = country[RowKey]
soccermasterdata[RowKey] = devicedetails[Match]
Also country[RowKey] = devicedeatils[Match] . I have a slicer which uses the country field from the country coloum. The field , viewership minutes from soccermasterdata is being filtered properly, but when i try to take the unique count of deviceid from devicedetails table, it is not working.
Can you please help me with this? Thanks in advance.