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

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