iscrossfiltered
1 Topic
PowerBI calculated measure - DAX
Hi Everyone, I have created a measure which calculates KPI based on selection in Slicer; when the particular product "A" or "B" or "C" is selected then the measure value returns, but when I have two different values selected in slicer like (A and B) - my calculated measure returns an error. My Slicer has distinct values like A,B,C to make selection. Please suggest - Below is my calculated measure : TARGET = IF ( ISCROSSFILTERED ( Product[Product_Type] ), SWITCH ( TRUE (), VALUES ( Product[Product_Type] ) = "A", ( ( CALCULATE ( SUM ( RM[Dollar] ), RM[STATE] <> "TX", YEAR ( RM[Date] ) = 2020 ) / 12 ) * 1.10 ) + ( ( CALCULATE ( SUM ( RM[Dollar] ), RM[STATE] = "TX", YEAR ( RM[Date] ) = 2020 ) / 12 ) * ( 0.43 ) ), VALUES ( Product[Product_Type] ) = "B", ( ( CALCULATE ( SUM ( RM[Dollar] ), YEAR ( RM[Date] ) = 2020 ) / 12 ) * 1.07 ), VALUES ( Product[Product_Type] ) = "C", ( ( CALCULATE ( SUM ( RM[Dollar] ), YEAR ( RM[Date] ) = 2020 ) / 12 ) * 1.10 ), BLANK () ), BLANK () ) Greg_Deckler,@v-jiascu-msft Anonymous selimovd Fowmy amitchandak parry2k Jihwan_KimSolved1.6KViews0likes5Comments