Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
The short question is - how would slice a count?
My company is trying to view trends in the type and amount of datasets that our customers are downloading.
We have becoming interested in customers download one file and never come back. We want to look at all of these all of these single downloads and see if there is a trend.
Ideally I would like to have slicer where we can select a range of downloads and see what
In this specific example I would like to be able to just view what the people who are downloading 1 data set ( by using a slicer but how ) and then viewing the percentage break down. In reality we would want to be able to have a range of downloads we were downloads we were slicing the data by.
Note: The supplied example is very small sample example of the amount downloads we have. The actional amount of records is 100000 plus.
Any advice is welcome.
Solved! Go to Solution.
Hi @steambucky
Sorry for releying late, please look at my file.
calculated column
count of email address = CALCULATE(DISTINCTCOUNT(Sheet2[email address]),ALLEXCEPT(Sheet2,Sheet2[data download]))
select "don't summarize", instead of any aggreation.
Best Regards
Maggie
How would I add a count as an additional field in a slicer?
I have a map report with properties in US states. My current slicer is STATE.
I want to add the count of properties in each STATE on my slicer for my users. I need guidance on how to do this.
Example:
[check box] AK 4
[check box] AL 7
[check box] AZ 2
[check box] CA 9
Thanks.
Hi @steambucky
What should the " a range of downloads" be?
Look at my test, based on your screenshot, create a calculated column "data" to distinguish the data type
data = IF(LEFT([data download],10)="data type",LEFT([data download],10),LEFT([data download],9))
Then import a customer visual "Hierarchy Slicer" from marketplace.
Add "data" and "data download" to the slicer
Best Regards
Maggie
Hello @v-juanli-msft,
Thanks for taking the time to reply. I read your answer but am unsure how to apply it to my query. I apologise, I dont think i have supplied enough detail to my intial query.
What I want to do slice buy the number of downloads, but I think I need to show what I am looking for visually?
Image 1 - we have numbers of downloads and the the downloads in percentages. Some data is is more popular than others.
Image 2 - If i select all the one time downloaders i can see want they down load and can start looking for trends. What I am after is a slicer that I can select any download amount and see what that "bracket" of our downloaders. We may be interested just looking at the higgest downloaders and so on.
Because of the amount of downloaders, it just is impossible to select them invidually.
Thoughts?
Hi @steambucky
What I am after is a slicer that I can select any download amount and see what that "bracket" of our downloaders. We may be interested just looking at the highest downloaders and so on.
Do you mean add the “count of email address” column to a slicer for selecting any download amount,
Here “count of email address” is a calculated column instead of a measure.
and what do you mean by “look at the highest downloaders”?
Best Regards
Maggie
Hello Maggie @v-juanli-msft,
This is EXACTLY what I am looking for. Thanks SO much. I still need a hand re-creating your slicer.
I have created a calculated column, but regardless of which count type or options on the values i use ( see pics below ) , I can't create a similar Slicer as the one you have made. I can only suspect i am making a simple error somewhere.
You you advise with count type and value options ( count distinct? )
Thanks so much in advance.
Hi @steambucky
Sorry for releying late, please look at my file.
calculated column
count of email address = CALCULATE(DISTINCTCOUNT(Sheet2[email address]),ALLEXCEPT(Sheet2,Sheet2[data download]))
select "don't summarize", instead of any aggreation.
Best Regards
Maggie
How would I add a count as an additional field in a slicer?
I have a map report with properties in US states. My current slicer is STATE.
I want to add the count of properties in each STATE on my slicer for my users. I need guidance on how to do this.
Example:
[check box] AK 4
[check box] AL 7
[check box] AZ 2
[check box] CA 9
Thanks.
Thanks so much for your help! 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |