Forum Discussion

jacosmit's avatar
jacosmit
Regular Visitor
7 years ago
Solved

Filter in DISTINCTCOUNT question

New to the forum. Snippet of db below.   Using Powerbi I would like to figure out how many staff ate at the restaurant. But I only want them to be counted if they ate at the restaurant more than 5...
Need Help
  • themistoklis's avatar
    themistoklis
    7 years ago

    jacosmit

     

    Create a new measure using the following formula

     

    Measure = DISTINCTCOUNT(Table[Meal])

    Then create a table and add UserID, Month as Dimensions and the measure.

     

    See workspace on this link

     

    Also you can use the filter pane to filter those who ate more than 5 times

     

themistoklis's avatar
themistoklis
Icon for Community Champion rankCommunity Champion
7 years ago

jacosmit

 

Create a new measure using the following formula

 

Measure = DISTINCTCOUNT(Table[Meal])

Then create a table and add UserID, Month as Dimensions and the measure.

 

See workspace on this link

 

Also you can use the filter pane to filter those who ate more than 5 times