Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Good morning community,
I have a table with the reviews and the percentages that it supposes for each seller, but I would like to create a range of percentages, where it will indicate how many reviews are between 0% and 30%, how many between 30% and 90% and how many between 90% and 100%.
I accompany an image to better understand what I need.
Thank you all very much for your help!
Hello @Syndicate_Admin ,
Thank you very much for your quick response. I really believe that it is the solution, but for some reason he tells me all of them and puts me that, although they have percentages higher than 30%, they are within the range between 0% and 30%.
I think I have to look at other details, such as the relationships or calculations that are involved in the creation of the table.
Thank you very much again for your help.
Best regards
Jose Luis
Hi,
I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.
Revisiones measure: =
SUM( Data[Revisiones] )
Percentage: =
DIVIDE (
[Revisiones measure:],
CALCULATE ( [Revisiones measure:], ALLSELECTED ( Data[Cliente] ) )
)
Group: =
VAR _percentage = [Percentage:]
RETURN
SUMMARIZE (
FILTER ( 'Group', _percentage >= 'Group'[Min] && _percentage < 'Group'[Max] ),
'Group'[Group]
)
Clinete count by group: =
COUNTROWS (
FILTER (
VALUES ( Data[Cliente] ),
[Percentage:] >= MAX ( 'Group'[Min] )
&& [Percentage:] < MAX ( 'Group'[Max] )
)
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
87 | |
78 | |
62 | |
61 | |
60 |
User | Count |
---|---|
160 | |
114 | |
100 | |
74 | |
65 |