Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
Hi,
I have a set of data in which it has 100 rows filled with repeated names. I need to create a Gauge chart with the below condition. Please help me to get it solved as I am new to Power BI.
Condition: Value = count of filtered name / total count (i.e. 100)
For example: I have 100 rows with names as A, B, C, D & E which are repeatative. If count of A is 26, then value = 26/100 = 0.26, this should go as data for "Value" field while creating Gauge Chart. I will be having silcer to select the required option to know the value.
Solved! Go to Solution.
Hi @Dineshkumar91 ,
I tried to create your model with the following data (only 10 rows but the idea remains the same):
Here is what I can get:
The measure I used is as follows:
# names =
DIVIDE(
COUNTROWS( 'Table' ),
CALCULATE(
COUNTROWS( 'Table' ),
ALL( 'Table'[Name] )
)
)
If I answered your question, please mark my post as a solution.
Best,
Hi @Dineshkumar91 ,
I tried to create your model with the following data (only 10 rows but the idea remains the same):
Here is what I can get:
The measure I used is as follows:
# names =
DIVIDE(
COUNTROWS( 'Table' ),
CALCULATE(
COUNTROWS( 'Table' ),
ALL( 'Table'[Name] )
)
)
If I answered your question, please mark my post as a solution.
Best,
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
72 | |
67 | |
67 | |
42 | |
42 |
User | Count |
---|---|
46 | |
40 | |
28 | |
26 | |
25 |