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.
Can you help me in creating a visualization on number of Users logged in Quarterly, Half Yearly and Yearly in percentage.
Example
Raw data consists of Quarter, Year, User and Country
1:User Sam 10% of total users logged in Q12013 (3 months, Last 3 month)
2:User Yan 70% of total users logged in Q1 & Q2 2016 (6 months)
Quarter | Year | First Name | Country |
3 | 2019 | abhilash | India |
2 | 2019 | abhilash | India |
3 | 2019 | abhilash | India |
3 | 2019 | abhilash | India |
3 | 2015 | abhilash | India |
4 | 2015 | abhilash | India |
4 | 2014 | abhilash | India |
2 | 2018 | abhilash | India |
3 | 2017 | abhilash | India |
3 | 2019 | abhilash | India |
4 | 2018 | abhilash | India |
1 | 2013 | abhilash | India |
2 | 2019 | abhilash | India |
2 | 2018 | abhilash | India |
3 | 2019 | abhilash | India |
3 | 2019 | abhilash | India |
2 | 2019 | abhilash | India |
3 | 2017 | abhilash | India |
3 | 2019 | abhilash | India |
1 | 2018 | abhilash | India |
3 | 2018 | abhilash | India |
3 | 2019 | abhilash | India |
2 | 2019 | abhilash | India |
1 | 2015 | abhilash | India |
4 | 2013 | abhilash | India |
3 | 2017 | abhilash | India |
2 | 2019 | abhilash | India |
2 | 2018 | abhilash | India |
3 | 2019 | abhilash | India |
2 | 2019 | abhilash | India |
3 | 2019 | abhilash | India |
3 | 2019 | abhilash | India |
3 | 2019 | abhilash | India |
3 | 2019 | Arijit | India |
3 | 2019 | arshad | India |
3 | 2019 | Aseem | India |
3 | 2019 | ashvin | India |
3 | 2019 | asrujit | India |
2 | 2019 | Atul | India |
2 | 2019 | Atul | India |
2 | 2018 | Atul | India |
2 | 2019 | Atul | India |
3 | 2019 | Atul | India |
4 | 2018 | Atul | India |
3 | 2015 | Atul | India |
2 | 2019 | Atul | India |
3 | 2017 | Atul | India |
3 | 2019 | Atul | India |
3 | 2019 | Atul | India |
2 | 2019 | Atul | India |
2 | 2016 | Atul | India |
3 | 2019 | Atul | India |
2 | 2019 | Atul | India |
2 | 2019 | Atul | India |
4 | 2016 | Atul | India |
3 | 2019 | Atul | India |
4 | 2018 | Atul | India |
2 | 2018 | Atul | India |
3 | 2019 | Atul | India |
3 | 2019 | Atul | India |
1 | 2019 | Atul | India |
3 | 2019 | Atul | India |
2 | 2018 | Atul | India |
3 | 2019 | Atul | India |
2 | 2019 | Atul | India |
2 | 2018 | Atul | India |
3 | 2019 | Atul | India |
3 | 2019 | Atul | India |
2 | 2018 | Atul | India |
3 | 2019 | Atul | India |
3 | 2018 | Atul | India |
3 | 2019 | Atul | India |
3 | 2019 | Atul | India |
4 | 2016 | Atul | India |
3 | 2019 | Atul | India |
2 | 2018 | Atul | India |
2 | 2019 | Atul | India |
3 | 2019 | Atul | India |
4 | 2018 | Gyanendra | India |
4 | 2017 | HAREKRISHNA | India |
4 | 2015 | harish | India |
3 | 2019 | harpreet | India |
3 | 2019 | Harry | India |
3 | 2019 | Har**bleep**a | India |
2 | 2019 | hemraj | India |
2 | 2019 | hitesh | India |
3 | 2019 | imran | India |
3 | 2017 | Irshad | India |
2 | 2019 | Irshad | India |
3 | 2019 | Irshad | India |
2 | 2019 | Irshad | India |
3 | 2019 | Irshad | India |
2 | 2018 | Irshad | India |
2 | 2017 | Irshad | India |
3 | 2019 | Irshad | India |
3 | 2019 | Irshad | India |
2 | 2019 | Irshad | India |
3 | 2019 | Irshad | India |
3 | 2017 | Irshad | India |
3 | 2019 | Irshad | India |
2 | 2018 | Irshad | India |
3 | 2019 | Irshad | India |
2 | 2018 | Irshad | India |
3 | 2019 | Irshad | India |
3 | 2019 | Irshad | India |
3 | 2016 | Irshad | India |
2 | 2019 | Irshad | India |
2 | 2018 | Irshad | India |
4 | 2018 | Irshad | India |
3 | 2019 | Irshad | India |
3 | 2019 | Irshad | India |
2 | 2017 | Irshad | India |
4 | 2018 | Irshad | India |
3 | 2019 | Irshad | India |
2 | 2018 | Irshad | India |
2 | 2018 | Irshad | India |
4 | 2018 | Irshad | India |
3 | 2019 | Irshad | India |
3 | 2017 | Irshad | India |
3 | 2019 | Irshad | India |
3 | 2015 | Irshad | India |
3 | 2019 | Irshad | India |
3 | 2019 | Irshad | India |
4 | 2015 | Irshad | India |
3 | 2019 | Irshad | India |
4 | 2016 | Irshad | India |
3 | 2018 | Irshad | India |
3 | 2019 | Irshad | India |
4 | 2016 | Irshad | India |
2 | 2018 | Irshad | India |
3 | 2019 | Irshad | India |
2 | 2018 | Irshad | India |
2 | 2019 | Irshad | India |
2 | 2019 | Irshad | India |
2 | 2019 | Irshad | India |
2 | 2019 | Irshad | India |
3 | 2019 | Irshad | India |
2 | 2019 | Irshad | India |
2 | 2019 | Irshad | India |
3 | 2019 | Irshad | India |
2 | 2017 | Irshad | India |
2 | 2018 | Irshad | India |
2 | 2019 | Irshad | India |
2 | 2019 | Irshad | India |
2 | 2018 | Irshad | India |
2 | 2018 | Irshad | India |
3 | 2017 | Irshad | India |
3 | 2019 | Irshad | India |
3 | 2019 | Irshad | India |
2 | 2019 | Irshad | India |
3 | 2019 | Irshad | India |
3 | 2016 | Irshad | India |
2 | 2019 | Irshad | India |
3 | 2019 | Irshad | India |
3 | 2018 | Irshad | India |
3 | 2019 | Irshad | India |
3 | 2019 | Irshad | India |
2 | 2019 | Irshad | India |
3 | 2019 | Irshad | India |
3 | 2019 | Irshad | India |
4 | 2016 | Irshad | India |
4 | 2016 | Irshad | India |
2 | 2019 | Irshad | India |
2 | 2019 | Irshad | India |
3 | 2019 | Irshad | India |
2 | 2018 | Irshad | India |
2 | 2018 | Irshad | India |
2 | 2018 | Irshad | India |
3 | 2016 | Irshad | India |
2 | 2018 | Irshad | India |
3 | 2019 | Irshad | India |
3 | 2017 | Irshad | India |
2 | 2018 | Irshad | India |
2 | 2019 | Irshad | India |
2 | 2019 | Irshad | India |
2 | 2019 | Irshad | India |
3 | 2019 | Irshad | India |
3 | 2019 | Irshad | India |
3 | 2019 | Irshad | India |
3 | 2019 | Irshad | India |
2 | 2019 | Irshad | India |
2 | 2015 | Irshad | India |
2 | 2016 | Irshad | India |
3 | 2018 | Irshad | India |
2 | 2018 | Irshad | India |
3 | 2019 | Irshad | India |
3 | 2019 | Irshad | India |
2 | 2019 | Irshad | India |
2 | 2019 | Irshad | India |
2 | 2018 | SANDEEP | India |
3 | 2017 | sandip | India |
2 | 2019 | SANJAY | India |
4 | 2018 | sanjiv | India |
3 | 2015 | sanjiv | India |
2 | 2019 | sanjiv | India |
2 | 2019 | sanjiv | India |
3 | 2019 | sanjiv | India |
2 | 2019 | sanjiv | India |
3 | 2019 | sanjiv | India |
2 | 2019 | sanjiv | India |
2 | 2019 | sanjiv | India |
2 | 2019 | sanjiv | India |
2 | 2019 | sanjiv | India |
3 | 2019 | sanjiv | India |
4 | 2016 | sanjiv | India |
3 | 2019 | sanjiv | India |
3 | 2019 | sanjiv | India |
2 | 2018 | sanjiv | India |
3 | 2019 | sanjiv | India |
4 | 2016 | sanjiv | India |
2 | 2018 | sanjiv | India |
3 | 2019 | sanjiv | India |
3 | 2017 | sanjiv | India |
2 | 2019 | sanjiv | India |
3 | 2019 | sanjiv | India |
4 | 2018 | sanjiv | India |
3 | 2019 | sanjiv | India |
3 | 2019 | sanjiv | India |
4 | 2018 | sanjiv | India |
2 | 2019 | sanjiv | India |
2 | 2018 | sanjiv | India |
1 | 2019 | sanjiv | India |
3 | 2019 | sanjiv | India |
2 | 2018 | sanjiv | India |
3 | 2019 | sanjiv | India |
3 | 2019 | sanjiv | India |
4 | 2016 | sanjiv | India |
1 | 2019 | sanjiv | India |
3 | 2019 | sanjiv | India |
3 | 2019 | sanjiv | India |
2 | 2019 | sanjiv | India |
3 | 2019 | sanjiv | India |
2 | 2019 | sanjiv | India |
3 | 2018 | sanjiv | India |
1 | 2014 | sanjiv | India |
3 | 2019 | sanjiv | India |
4 | 2016 | sanjiv | India |
3 | 2017 | sanjiv | India |
2 | 2019 | sanjiv | India |
3 | 2019 | sanjiv | India |
3 | 2019 | sanjiv | India |
2 | 2019 | sanjiv | India |
3 | 2019 | sanjiv | India |
2 | 2019 | sanjiv | India |
2 | 2016 | sanjiv | India |
2 | 2019 | sanjiv | India |
4 | 2015 | sanjiv | India |
2 | 2019 | sanjiv | India |
3 | 2015 | sanjiv | India |
2 | 2018 | sanjiv | India |
3 | 2019 | sanjiv | India |
3 | 2019 | sanjiv | India |
4 | 2015 | sanjiv | India |
3 | 2019 | Vimal | India |
3 | 2019 | Vinayagam | India |
4 | 2016 | VIRAJ | India |
3 | 2019 | Vishnu | India |
1 | 2019 | Vishwanath | India |
4 | 2018 | yasir | India |
3 | 2019 | YATIN | India |
3 | 2019 | YOGESH | India |
2 | 2019 | Yogeshwara Rao | India |
3 | 2019 | YUVARAJ | India |
2 | 2019 | ZAFAR | India |
Thanks & Regards,
San
Solved! Go to Solution.
Hi @Anonymous
You could create a measure as below
Measure 2 = IF ( ISINSCOPE ( 'Table'[Year] ), IF ( ISINSCOPE ( 'Table'[half year column] ), IF ( ISINSCOPE ( 'Table'[Quarter] ), COUNT ( 'Table'[First Name] ) / CALCULATE ( COUNT ( 'Table'[First Name] ), ALLEXCEPT ( 'Table', 'Table'[Year], 'Table'[half year column] ) ), COUNT ( 'Table'[First Name] ) / CALCULATE ( COUNT ( 'Table'[First Name] ), ALLEXCEPT ( 'Table', 'Table'[Year] ) ) ), COUNT ( 'Table'[First Name] ) / CALCULATE ( COUNT ( 'Table'[First Name] ), ALL ( 'Table' ) ) ), 1 )
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
I can only create number of Users based on Quarterly, Half Yearly and Yearly, but i don't know how to calculate the percentage.
which is the molecule?
Create a column
half year column = IF([Quarter]<=2,"first half","second half")
Add column "'first name" in the "Value" field, and select "count"
then you can expand the levels in a matrix visual.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Maggie,
Am looking for deriving in percentage.
Hi @Anonymous
You could create a measure as below
Measure 2 = IF ( ISINSCOPE ( 'Table'[Year] ), IF ( ISINSCOPE ( 'Table'[half year column] ), IF ( ISINSCOPE ( 'Table'[Quarter] ), COUNT ( 'Table'[First Name] ) / CALCULATE ( COUNT ( 'Table'[First Name] ), ALLEXCEPT ( 'Table', 'Table'[Year], 'Table'[half year column] ) ), COUNT ( 'Table'[First Name] ) / CALCULATE ( COUNT ( 'Table'[First Name] ), ALLEXCEPT ( 'Table', 'Table'[Year] ) ) ), COUNT ( 'Table'[First Name] ) / CALCULATE ( COUNT ( 'Table'[First Name] ), ALL ( 'Table' ) ) ), 1 )
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |