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,
I have in a dataset(sql table) 3 columns : Inprogress, Resolved, Workaround that can have 5 posible values: 0-70%, 70-90%, 90%-100%, 100-120% , >120%
As a requiremnts it's the request to transform the values of these columns in categories and on colum to have a count of n=the number of occurances for each category, something like below:
Do you have an idea how I can solve it?
Thanks,
Irina
Solved! Go to Solution.
Hi @salexa ,
You can start by using the unpivot column in the power query like below:
then create below formula:
Measure = COUNTROWS('Table')
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @salexa ,
You can start by using the unpivot column in the power query like below:
then create below formula:
Measure = COUNTROWS('Table')
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
HI,
thanks fo replying, I've check it and it seems to work in import.
but i forgot to mention that my powerbi report it's linked to a Tabular cube, live connection so I can't apply Power Query.
Tahnks,
Irina
@salexa , Are you looking to bucket a measure?
is so refer
Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1...
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k
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 | |
106 | |
87 | |
73 | |
66 |
User | Count |
---|---|
124 | |
113 | |
98 | |
81 | |
72 |