Forum Discussion

ckausihan_12's avatar
ckausihan_12
Icon for Helper I rankHelper I
6 years ago
Solved

Dynamic table comparison

Hi, I have two tables, table 1 contains users site access data and table 2 contains a list of all users in the organisation (please see below). I am trying to create a page which will show me a list ...
Need Help
Tutorial Requests
  • VijayP's avatar
    VijayP
    6 years ago

    ckausihan_12 

     

    To Get Time intelligence you need to have date table. With Date Table you can drill down who are Visitors and Non Visitors.

    I am attaching PBIX File here. you can go thru to understand the Table

     

    I have created a Measure showing number of Visitors  SUM(Visitor ID) and then calculated Non Visitors based on total Visits = 0

    I think PBIX File will help  you a lot.  Please Clik on this LINK

    If you find this as Solution please mark this as Solution and Share your Kudos.

    Also you cant Watch my Power BI and Excel Videos at www.youtube.com/perepavijay

    Regards

    Vijay Perepa

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

If Table 2, is master table then have a measure

 

Count = count(Table[username])+0

 

And now filter for count =0 (Visual filter). Also, use this option, if needed