dynamicmeasure
2 TopicsCustom Measure not working on Pie Chart Visual
Hello Team/ Uspace87 , I have created a custom measure , which I want to use as a filter in pie chart visual. When I apply this filter , it gets applied on the "Legend" but not on the "Values" of the pie chart visual. Please assist. My exact use case is as follows : 1.The default behaviour of the checkbox slicer in Power BI is that it shows the result of OR when you select multiple items , I wanted to convert checkbox slicer to AND logic upon multiple selection. 2. I took the help of following link to create a custom measure : https://radacad.com/slicer-with-and-condition-in-power-bi 3. The custom measure is working correctly on table visual but when I try to use the same on pie chart I am facing the abovementioned issue. Please suggest if not custom measure then what is the correct way to solve my use case. Thanks Deesha573Views0likes0CommentsPowerBI 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