Forum Discussion

dapling's avatar
dapling
Frequent Visitor
8 years ago
Solved

Frequency calc / Histogram

Hi, I am new to PowerBI and have a (hopefully) simple question about how to create a frequency table and ultimately a histogram.   My data is laid out as follows:   VisitID  SiteID  CustID 1    ...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    dapling

     

    Hi David,

     

    Delete the column "CustID" from Summary. I found that the visual is correct now. Please check the file here: https://1drv.ms/u/s!ArTqPk2pu-BkgSqND4imKbOYtOeh

    Summary = 
SUMMARIZE (
    'Visits',
    'Visits'[Site id],
    "Fres", COUNT ( Visits[Site id] )
)


     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards!

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi dapling,

 

Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.

 

Best Regards!
Dale

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi dapling,

     

    1. Update the relationships as the picture showed.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    2. Create the visuals like this:

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    You can check it out in this file: https://1drv.ms/u/s!ArTqPk2pu-BkgSn1uv0UV2PlYlo2.

     

    Best Regards!

    Dale

    • dapling's avatar
      dapling
      Frequent Visitor
      8 years ago

      Hi Dale, I really appreciate your help, but I'm afraid this is still not what I'm trying to achieve.

       

      The table needs to be capable of identifying that there is a single instance (occurence) of a site (owned by PQR) which has been visited FIVE times, none visited FOUR times, 1 visited THREE times (also PQR's site), 1 site visited TWICE (owned by MNO) and 4 sites visited ONCE (2 owned by MNO and 2 by PQR).

       

      Freq * Site Count 

      [5*1] + [4 *0] + [3*1] + [2*1] + [1*4] = 14.

       

      i.e. 14 visits in total to 7 different sites, BUT split by two different owners.

       

      The Cust id is no longer relevant for this slice.

       

      Confusing... Argh!!!  I've saved my amended file in the same shared place as above.

       

      Thanks again, David

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Microsoft Employee
        8 years ago

        dapling

         

        Hi David,

         

        Delete the column "CustID" from Summary. I found that the visual is correct now. Please check the file here: https://1drv.ms/u/s!ArTqPk2pu-BkgSqND4imKbOYtOeh

        Summary = 
SUMMARIZE (
    'Visits',
    'Visits'[Site id],
    "Fres", COUNT ( Visits[Site id] )
)


         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

        Best Regards!

        Dale