Forum Discussion
thorpyuk
Helper III
6 years agoCount unique orderers
Hi All, I have a sales table, and a site table, linked on [TerminalID] which is the till number. I want to count the unique ordering sites for each individual product that might be ordered... [Prodc...
- Anonymous6 years ago
You can create the relationship in the Model pane of in Power BI (see image).
If you are unable to create the relationship, then your measure will need to use the LOOKUPVALUE. Try this:
Ordering Sites = COUNTROWS( SUMMARIZE( ADDCOLUMNS( 'Sales', "SiteID", LOOKUPVALUE(Terminal[SiteID], Terminal[TerminalID], Sales[TerminalID]) ), [SiteID] ) )
thorpyuk
Helper III
6 years agoAnyone any other suggestions?
- camargos886 years ago
Community Champion
thorpyuk ,
Have you tried to count by the id for the site table ?
Something like:
DISTINCTCOUNT(ID_SITE_TABLE)
Ricardo
- thorpyuk6 years ago
Helper III
Hi Camargos88, yes that just gives me the total number of distinct sites (56) against each product, but i want only the number of those sites that have ordered
- camargos886 years ago
Community Champion