Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Gauge Chart Dynamic Maximum Value

Hi all, I am trying to create a gauge chart with a dynamic maximum value based on the slicer filters (Category & Query & Date Range) on the dashboard. I am in the marketing industry and am trying t...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi tamerj1 
    I got it to work!! Thank you so so much for helping me out! 

    Current CTR (Gauge) = 
CALCULATE(
    [Avg CTR],
    FILTER(
        'GSC query analysis',
        RELATED('Calendar Lookup'[Start of Month]) = MAXX('Calendar Lookup', 'Calendar Lookup'[Start of Month])
    )
)

     

     

tamerj1's avatar
tamerj1
Community Champion
4 years ago

Anonymous 

Also please try

 

 

Max CTR =
CALCULATE (
    MAXX (
        CROSSJOIN (
            VALUES ( 'Calendar Lookup'[Start of Month] ),
            SUMMARIZE (
                'GSC query analysis',
                'GSC query analysis'[Category],
                'GSC query analysis'[Query]
            )
        ),
        CALCULATE ( DIVIDE ( [Sum Clicks], [Sum Impressions], 0 ) )
    ),
    REMOVEFILTERS ( 'GSC query analysis' ),
    ALLSELECTED ( 'Calendar Lookup' )
)

 

 
Anonymous's avatar
Anonymous
Not applicable
4 years ago

I tried this code, but they all show 1