Forum Discussion
AZJohnPowerBI
Helper I
Helper ITotal Bar over Months
Greg_Deckler amitchandak I am trying to get a graph divided by months to show a total bar. When I use a similar dax formula by categories to show a total bar, it works fine. When I try to create ...
AZJohnPowerBIHelper I
Helper IThere's a new problem on this, after the update.
The same code format works on 4 of the graphs, but not another.
Total_TypeBar =
SWITCH( TRUE (),
SELECTEDVALUE( TotalBar_Type[Type] ) = "Total"
, CALCULATE( SUM('Fact Epic'[Scheduled Appointments]), ALL ( TotalBar_Type[Type] ) )
, SUM( 'Fact Epic'[Scheduled Appointments] ))
Totals_HandleRatio =
SWITCH(TRUE(),
SELECTEDVALUE(Total_Bar_CSQ[CSQ Name]) = "Total"
, CALCULATE(AVERAGE('Fact Cisco'[Handle Ratio]), ALL(Total_Bar_CSQ[CSQ Name]))
, AVERAGE('Fact Cisco'[Handle Ratio]))
For example, used to work fine. Now, only the first code mentioned works but not the second code.
Any help would be greatly appreciated.