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 a column with 3 different entries in it (Early, Late & On-Time). I'm looking to count the number of entries for each and then have that as a percentage of the total amount of entries (i.e. 100 entries, 10 are on time, therefore return 10%).
Is this possible..?
Many Thanks
Mike.
Solved! Go to Solution.
@Smithy33
Create the following Measure and Replace your Column name:
Measure1 =
DIVIDE (
COUNTA ( 'Product'[Category] ),
CALCULATE ( COUNTA ( 'Product'[Category] ) , ALLSELECTED('Product'[Category] ) )
)
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Smithy33 , Of the way
a new measure =
divide(countrows(Table), calculate(countrows(Table), allselected(Table))
Plot with status and mark as % measure
Hi - Thanks for your prompt reply. Doesnt look like it's liking the proposed DAX.....I need to be able to select a specific column in the table where all the 3 entries are in, which it doesnt seem to want to do.
@Smithy33
Create the following Measure and Replace your Column name:
Measure1 =
DIVIDE (
COUNTA ( 'Product'[Category] ),
CALCULATE ( COUNTA ( 'Product'[Category] ) , ALLSELECTED('Product'[Category] ) )
)
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
I am struggling with a similar problem. However the solution is not working fo me.
I am considering 'Product' as table name and 'category' as column name. where can i add my value which is on-time/delay?
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |