Forum Discussion
Solved
Creating a Chart with x axis to be dynamic
Hello, I am trying a develop a graph using the below data OrderNo OrdDate CallType CallDate CallID A123 12/20/2022 Initial 1/2/2023 C1234 A123 12/20/2022 Initial 1/2/2023 C123...
Hi PBI5851 ,
I've tried to recreate what i believe is your end-goal.
How does this match your intended output?
It's done with the following measures:Shipping Call Count = VAR totalOrders = CALCULATE( DISTINCTCOUNT( Orders[OrderNo] ) , REMOVEFILTERS( Orders[CallDate] )) VAR WithCalls = COUNTROWS( FILTER ( SUMMARIZE( Orders , Orders[OrderNo] , Orders[CallType] , "Value" , COUNTROWS( Orders ) ) , [Value] >= 1 && Orders[CallType] = "Shipping") ) Return SWITCH( SELECTEDVALUE( 'Count'[Count] ) , "0" , totalOrders - WithCalls , "1" , WithCalls )Service Call Count = VAR totalOrders = CALCULATE( DISTINCTCOUNT( Orders[OrderNo] ) , REMOVEFILTERS( Orders[CallDate] )) VAR WithCalls = COUNTROWS( FILTER ( SUMMARIZE( Orders , Orders[OrderNo] , Orders[CallType] , "Value" , COUNTROWS( Orders ) ) , [Value] >= 1 && Orders[CallType] = "Service") ) Return SWITCH( SELECTEDVALUE( 'Count'[Count] ) , "0" , totalOrders - WithCalls , "1" , WithCalls )Initial Call Count = VAR totalOrders = CALCULATE( DISTINCTCOUNT( Orders[OrderNo] ) , REMOVEFILTERS( Orders[CallDate] )) VAR WithCalls = COUNTROWS( FILTER ( SUMMARIZE( Orders , Orders[OrderNo] , Orders[CallType] , "Value" , COUNTROWS( Orders ) ) , [Value] >= 1 && Orders[CallType] = "Initial") ) Return SWITCH( SELECTEDVALUE( 'Count'[Count] ) , "0" , totalOrders - WithCalls , "1" , WithCalls )
Plus a small static table to populate the x-axis:
/ J
Hi PBI5851 ,
I've tried to recreate what i believe is your end-goal.
How does this match your intended output?
It's done with the following measures:
Shipping Call Count =
VAR totalOrders = CALCULATE( DISTINCTCOUNT( Orders[OrderNo] ) , REMOVEFILTERS( Orders[CallDate] ))
VAR WithCalls = COUNTROWS( FILTER ( SUMMARIZE( Orders , Orders[OrderNo] , Orders[CallType] , "Value" , COUNTROWS( Orders ) ) , [Value] >= 1 && Orders[CallType] = "Shipping") )
Return
SWITCH( SELECTEDVALUE( 'Count'[Count] ) ,
"0" , totalOrders - WithCalls ,
"1" , WithCalls
)Service Call Count =
VAR totalOrders = CALCULATE( DISTINCTCOUNT( Orders[OrderNo] ) , REMOVEFILTERS( Orders[CallDate] ))
VAR WithCalls = COUNTROWS( FILTER ( SUMMARIZE( Orders , Orders[OrderNo] , Orders[CallType] , "Value" , COUNTROWS( Orders ) ) , [Value] >= 1 && Orders[CallType] = "Service") )
Return
SWITCH( SELECTEDVALUE( 'Count'[Count] ) ,
"0" , totalOrders - WithCalls ,
"1" , WithCalls
)Initial Call Count =
VAR totalOrders = CALCULATE( DISTINCTCOUNT( Orders[OrderNo] ) , REMOVEFILTERS( Orders[CallDate] ))
VAR WithCalls = COUNTROWS( FILTER ( SUMMARIZE( Orders , Orders[OrderNo] , Orders[CallType] , "Value" , COUNTROWS( Orders ) ) , [Value] >= 1 && Orders[CallType] = "Initial") )
Return
SWITCH( SELECTEDVALUE( 'Count'[Count] ) ,
"0" , totalOrders - WithCalls ,
"1" , WithCalls
)
Plus a small static table to populate the x-axis:
/ J
