Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Team,
I have Following Data-set
Hospitals
Abn Group
CCAD
NMC Group
Imperial College
Prime Healthcare
I have inserted this Hospitals data in to slicers
My requirement is when
i select 1 data point in Hospitals it should show 20% in guage chart
if i select 2 data point in Hospitals it should show 40% in guage chart and so one........
Please look into this
Solved! Go to Solution.
Hi, @RAHULBANDI ;
Try it.
Measure = DIVIDE( COUNT(Test[Hospitals]),CALCULATE(COUNT(Test[Hospitals]),ALL(Test)))
Then change the type of this meausre.
The final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @RAHULBANDI ;
Try it.
Measure = DIVIDE( COUNT(Test[Hospitals]),CALCULATE(COUNT(Test[Hospitals]),ALL(Test)))
Then change the type of this meausre.
The final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@RAHULBANDI Try a measure like this:
Measure =
DIVIDE(
COUNTROWS(SUMMARIZE('Table',[Hospitals])),
COUNTROWS(SUMMARIZE(ALL('Table'),[Hospitals]))
)
Hi
Thq for your Reply
I have tried ur measure, but it s showing like this
I'm looking for 20%, 40%, 60% etc;
and i need the Gauge chart to fill accordingly
I have taken min = 1, max = 10
User | Count |
---|---|
94 | |
86 | |
78 | |
69 | |
63 |
User | Count |
---|---|
113 | |
99 | |
97 | |
64 | |
59 |