Forum Discussion

NeimadB's avatar
NeimadB
Helper II
4 years ago
Solved

Create a « Not In » Gauge

Hello there, I'm wondering which type of a charts or measures  I can use to create a "Not In" Gauge.   i have a bunch of restaurants, a list of clients and I want to determine which clients have...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    Hi NeimadB

     

    I mocked some data and created a sample on that. I used below measures. Download the attachment for details and adjust the measures to fit your data. 

    Total Clients = DISTINCTCOUNT('report ClientProfile'[ClientId])
    In Clients Count = 
VAR vYears = ALLSELECTED('report ClientProfile'[FiscalYearId])
VAR vClients = VALUES('report ClientProfile'[ClientId])
VAR vTable = FILTER('dimension Purchases','dimension Purchases'[FiscalYearId] IN vYears && 'dimension Purchases'[ClientId] IN vClients)
RETURN
CALCULATE(DISTINCTCOUNT('dimension Purchases'[ClientId]),vTable)

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

lbendlin's avatar
lbendlin
Super User
4 years ago

Use the clientid field from the client table, add a measure "Restaurants visited" and then enable "select items without data" - if you then filter the "Restaurants visited" to Blank  you get all the clients who did not visit any restaurants.