Frequency table for values in column selected by parameter

[bmcminn]

I have a parameter, with a slicer, for each column in a table. I want to make a histogram that would show the frequency for all the values in the selected column. How would I do this?

[bmcminn · Accepted solution]

So, depending on what you need, this is actually a pretty straightforward task. I'm not sure how to create a table that exists in the model, but to make it as a visualization is no big deal. Use a count of all the rows or unique IDs or whatever and the column from the parameter. I should have tried this initially.

[Ritaf1983]

Hi @bmcminn 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[bmcminn]

@Ritaf1983 Do you know of a way for me to upload a pbix file and demonstrate the parameter? I'm guessing that since you're a community champion you must.

---edit---
Here is a link to the pbix in google drive.
https://drive.google.com/file/d/1c6ReKmFrMUyguKDGKuPyIlAuX4h2ABWu/view?usp=sharing 

If not then the "example" would be this.

Column 1	Column 2
A	1
B	4
C	5
B	6
B	4

Result when Column 1 is chosen in the paramter.

Value	Count
A	1
B	3
C	1

I was able to create a frequency table for a specific column, using:
FrequencyTable = SUMMARIZE(Table, Table[Column 1], "Count", COUNTROWS(Table)
but trying to create a dynamic table by simply switching out the table/columns names for the corresponding parameter/paramter_column names but that returns the following error:
Parameter [Parameter Column 1] is part of composite key, but not all columns of the composite key are included in the expression or its dependent expression.

The next thing I'm going to try is to use SWITCH.

[Ritaf1983]

Hi @bmcminn 

Yes you can save your pbix on google drive or something similiar and share it with the link.

I will look on your example tomorrow , i am not near my comuter now

[bmcminn]

Thank you. I posted a link.