Forum Discussion

dapling's avatar
dapling
Frequent Visitor
9 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

CahabaData's avatar
CahabaData
Icon for Memorable Member rankMemorable Member
9 years ago

I don't see the logical construct for the resulting grid that you propose.  It is not clear how the Freq column is logically defined.

 

Readily available would be:

 

SiteID  CustID   Visits
123       ABC      1
345       ABC      3
678       XYZ      1
345       XYZ      1