Forum Discussion
Possible Analytics function: dynamic Total column in chart with USA States?
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 ) )
Hi v-chuncz-msft,
thank you for you idea, but how I can add now the sum of bottleneck and regular jobs for alle states and total?
Here's a part of my project and my connection.
I thought there would be a chart with the same "Total" function like with the table visualization.
Would be great if you could help me with this problem !
Facttable (ID = Key)
ValuetableCalculated columnConnection between Fact and ValuetableDiagramm and Table with Totals
BR,
Sven
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 )
)
Hi v-chuncz-msft;
thank you for your measure codes.
But unfortunately there's no other result:
No total dataYour measure codeConnecting Tables
Do you have any ideas why there's no solution?
BR,
Sven
Anonymous,
Remove the relationship between FactTable and Table.
Dear v-chuncz-msft,
Can you advise on adding an index column in calculated table 'Table', so I can sort the order of tenure categories on my chart properly? Otherwise the solution works great!
Thanks.