Change Field Parameter Names based on slicer selection
Hello, I have done a bit of searching but I couldnt find a solution or a workaround for this. Any help is much appreciated. I have created a Field Parameter Table with multiple measures. Each measure has a logic to calculate the sales and profit based on the selected month, say logic for 1st month of a Quarter - Jan, Apr, Jul, Oct is different from logic to calculate for 2nd month of a Quarter and so on. Now, the challenge is, based on the month selected from the slicers, I want the column name in the matrix to change. That is, if I select Jan or Apr or Jul or Oct, I want the parameter name "Month1 of Qtr Act" to be changed dynamically. I tried the SELECTEDVALUE('Calendar'[MonthName]) which doesnt work on Parameter Tables. Parameter = { ("Month1 of Qtr Act", NAMEOF('BPC_DAX'[Month_1_Q]), 0), ("Month2 of Qtr Act", NAMEOF('BPC_DAX'[Month_2_Q]), 1), ("Qtr_Implied", NAMEOF('BPC_DAX'[Qtr_Implied]), 2), ("Qtr_Estimated", NAMEOF('BPC_DAX'[Qtr_Estimated]), 3), ("Q1 Actuals", NAMEOF('BPC_DAX'[Q1_Actuals]), 4), ("Q2 Actuals", NAMEOF('BPC_DAX'[Q2_Actuals]), 5), ("Q3 Actuals", NAMEOF('BPC_DAX'[Q3_Actuals]), 6) } Thanks, Sandy
How to handle this requirement?
Hi all, I've been struggling with a scenario for a while which I want to solve properly. Below I've created a model which contains the relevant tables from a more complex data model. The requirement Calculate the following Divide this SUM(Fact_Marketvalue.Marketvalue) * SUM(Fact_Rating.Carbonemission) where the Fact_Ratings.Carbonemission > 5) by this SUM(Fact_Marketvalue.Marketvalue) > 5 ) The result should by sliceable by Category, Customer, Security and more Dimension tables in my model. Right now I created many-many relationships between Fact_MarketValue and Fact_Ratings on the Security ID, but I want to avoid this relationship. What would be the best thing to do? Create a view in SQL which holds all information needed, if so, I want to keep it as lean as possible? or should I create a bridge table, if so, with what information? Or maybe I am missing some DAX magic..Compare same measure in a chart with two sets of slicers (same slicers)
Hi all! I'm struggling with the following. I attached an image for better understanding I need to create a chart that plots a different measure based on selection. I know how to do that. The problem comes into play when I want to chart this measure comparing two same sets of slicers (I have 6 dimensions i need to use per each comparable). I have come to two possible solutions but they are not as clean as desired. One is overlapping two charts showng the same measure but adapting interactions between slicers and charts. The sencond one would be duplicating all dimensions tables/columns and duplicating all measures to use the ALLSELECTED function to adapt each measure to each set dimensions, but that would be messy. Any idea on how to make it? Thanks!
