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.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
4 years ago

Hi,

I am not sure if i can create a gauge chart for you but i can help you with writing a measure.  Share some data and show the expected result.