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.
im trying to convert a set of values derrived from ranking to there equivilant percentage.
the schema is as follows
Social Network CM Red Social | Users CM Red Social |
(not set) | 100 |
Academia | 454 |
Buzzfeed | 235 |
676 | |
Youtube | 33 |
67 | |
Meetup | 56 |
345 | |
(not set) | 234 |
Academia | 546 |
Buzzfeed | 676 |
87 | |
Youtube | 89 |
76 | |
Meetup | 45 |
78 |
i have one mesure that filters out a social network not needed and aggregates a total
with this measure in hand i have another measure that ranks and gets the top 5 social media users
how can i convert this to percentage knowing that the order and names can change dfrom day to day
im thinking i can use the divide feature with a ranking to 5 and filter out the unwanted social media
below is my current result i need that in percentage
thanks
Solved! Go to Solution.
fixed with the below
You may modify the measaure as below:
TopNRedSocial = IF ( RANKX ( ALL ( 'Grupo LD CM Red Social'[Social Network CM Red Social ] ), CALCULATE ( [Users CM Red Social Total] ) ) < 6, SUM ( 'Grupo LD CM Red Social'[Users CM Red Social] ) / CALCULATE ( SUM ( 'Grupo LD CM Red Social'[Users CM Red Social] ), ALL ( 'Grupo LD CM Red Social' ) ), BLANK () )
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
that gives me a percentage based on all the catagories including the ones not shown.
i changed the mesure to below
fixed with the below
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 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |