Dynamic Dax Measure
Hi guys, I am working on a dynamic dax measure which I like to use for one visual. Basically I want to have one visual that shows the costs. Based on the dynamic filter which I put into the x-axis field, the user is able to filter by various categories which come from various data sources. All are string values e.g by category, by city etc. I tried so many things but the Code just doesnt work. I dont want to create a extra table and merge all these categories inside, I just want it to work how it is. Thank you in advance! DynamicMeasureNEW = VAR SelectedColumn = SELECTEDVALUE(DynamicTable[Column1]) RETURN SWITCH ( SelectedColumn, "Delay Reason", VALUES(MedicallyFitForDischarge[FIT_REASON]), "Care Group", VALUES(Look_New_Trust_Hierarchy[CARE_GROUP]), "Specialty", VALUES(Look_Specialty[Specialty Description]), "Ward", VALUES(MedicallyFitForDischarge[LOCATION]), BLANK() // Return BLANK() for unmatched cases )Line Chart Not Filtering Correctly! Help!
Hi, I need some help. My line chart is not filtering when I click on a filter. Please see example below: Although one school is selected and one filter (A level) on the line chart all data is shown. The relationship is below and is active; I just want the line chart to show the filtered line, any help would be greatly appreciated! Thanks
Custom 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 Deesha
