Forum Discussion

RAHULBANDI's avatar
RAHULBANDI
Icon for Helper II rankHelper II
3 years ago
Solved

***Gauge Chart***

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...
Need Help
Show and Tell
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    3 years ago

    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.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

RAHULBANDI Try a measure like this:

Measure = 
    DIVIDE(
        COUNTROWS(SUMMARIZE('Table',[Hospitals])),
        COUNTROWS(SUMMARIZE(ALL('Table'),[Hospitals]))
    )