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 everyone, I'm new to power by and I want to obtain this results from my data
What I want to do is a running count based on the value in fields "Assigned To" that is numerically sorted like in the image below
Any suggestions? Thanks
Solved! Go to Solution.
Hi @Federico92 ,
this seems to work.
Count =
VAR OrderID = 'Sample Data'[Order]
RETURN
CALCULATE (
COUNTROWS ( 'Sample Data' ),
FILTER (
ALLEXCEPT ( 'Sample Data', 'Sample Data'[Group] ),
'Sample Data'[Order] <= OrderID
)
)
Hi @Federico92 ,
can you provide sample data and describe which column is used for sorting?
In the image with the expected result, I don't see any reference to the "Assigned To" column.
https://drive.google.com/file/d/1pTdvJHx7GQokfhmI4AiOxQIkWtCxR5WC/view?usp=sharing
Hi @Federico92 ,
this seems to work.
Count =
VAR OrderID = 'Sample Data'[Order]
RETURN
CALCULATE (
COUNTROWS ( 'Sample Data' ),
FILTER (
ALLEXCEPT ( 'Sample Data', 'Sample Data'[Group] ),
'Sample Data'[Order] <= OrderID
)
)
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 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |