Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Possible Analytics function: dynamic Total column in chart with USA States?

Hi Together!   Currently I'm trying to visualize a dynamic total column  in my chart with USA States (Red marked). The column should be seprated in bottleneck and regular jobs.   How I can realiz...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    Anonymous,

     

    Drag [State] from the calculated table to Axis and measures below to Value.

    Measure =
VAR s =
    SELECTEDVALUE ( 'Table'[State] )
RETURN
    IF (
        s = "Total",
        SUM ( ValueTable[Regular jobs] ),
        CALCULATE ( SUM ( ValueTable[Regular jobs] ), FactTable[State] = s )
    )

    Measure 2 =
VAR s =
    SELECTEDVALUE ( 'Table'[State] )
RETURN
    IF (
        s = "Total",
        SUM ( ValueTable[Bottleneck jobs] ),
        CALCULATE ( SUM ( ValueTable[Bottleneck jobs] ), FactTable[State] = s )
    )
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi v-chuncz-msft,

 

wooww! Thats kind of magic! It works!

Thank you soo much!

 

BR,

 

Sven

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hello everyone, 

I need the very same total but do not have any fact + value table. 
I only have one table with let's say 2 columns : 

State and amount 

I need a bar chart with 

Axis : state

Value : amount

with on the left or the right a basic total (like in Excel)

 

I tried clustered column chart. It works fine except there is no total option. 

Do I miss something?

 

I then tried to follow v-chuncz-msft solution but could not modify it to make it works with my simple data. 

Thanks for your help

Phil