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.
Hi experts,
I think this is a very basic problem. I hope you can help me.
I have been able to filter and get the number i want (31027) in the "table" vizualisation (bottom of the picture).
The filter does not work in a card (seen on the top of the picture)
The filter i need on the card is the distinct count of all the app id's who has more than 5 sessions.
See the picture below:
I am almost certain, that it has something to do with the distinctcount measure not being able to filter the way i want. I have tried to calculate with a filter, but it is not working out for me.
Any ideas?
Thank you very much 🙂
Solved! Go to Solution.
Hi
Try this measure and drag it to your visuals
=COUNTROWS(FILTER(SUMMARIZE(VALUES('qs v_FactUsage[AppId]),[AppId],"ABCD",[Uniquesessions's]),[ABCD]>5)
Hope this helps.
@Anonymous -
The problem is that "Distinct Counts" are semi-additive.
The Line Chart applies the calculation for each year, e.g. answers the question for 2018:
In 2018, how many products had a session count greater than 5?
The sum of the Line Chart could potentially be less than the Card if an App had 7 total sessions, but 3 were in 2017 and 4 in 2018 - in that case, the App, which is counted in the Card, would not be counted at all.
In other cases, the sum of the Line Chart could count the same App twice, e.g. it had more than 5 sessions in 2017 and more than 5 in 2018.
Hope this helps,
Nathan
Hi Natel,
Thanks for replying.
The only measures i have are:
DISTINCTCOUNT (AppID) called UniqueAppis's and DISTINCTCOUNT (SessID) called UniqueSessions.
I have included a picture of how my data structure and filters on the table - if that clarifies anything.
Please tell me if you need anything else 🙂
@Anonymous - Can you show the same information for the Card visual?
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |