How to set Default filter for Matrix or Table
Hi everyone, I want a matrix to show values for a particular filter, L1, from KPI Level by default. Note: I will use KPI Level as a slicer. When I click on the L2 slicer, the table should display L2 data. For L3 selection, it should show L3 data, and for L1, it should show L1 data. If no filters from the KPI Level slicer are selected, the table should display only L1 data by default. The table needs to include the following columns: - KPI Level - Region - Category - Target - Actual Below is the data view of the dataset: ChatGPT data prompt: https://chatgpt.com/share/b2a755d3-e928-4817-80ef-a643de3c6bf0 Dax formula i used: Defualt_Target = Var _a = SELECTEDVALUE(Data[KPI Level], "L1") Var _b = CALCULATE(sum(Data[Target]), FILTER(Data, Data[KPI Level]= _a )) RETURN _b I am not able to acheive the result what i wanted
ignore column value filter in a table visual
hello i have visual table with below fields' I'm trying to calculate the agent achievement which is made of 1- core achievement measue (which equals 90%* by new achiev% measure) 2- accessories achievement (which equals 10%* new achiev% measure) 3- total achievement (equals the sum of core achievement and accessories achievement) as you can see from the table above, i managed to to calculate the first 2 parts for core achievment and accessories achievement. the problem is when i was trying to sum the two percentages it's not working. as for [category type]= 'accessories' it will show blank in core achievment measure and for [category type]='Core' it shows blank for accessories achievement. i want to show the accessoreis achievemt '7%' instead of blank for category type ='core' so that for each core category i can sum both core and accessories achievement as below
How to prevent the measure result splitting over all the departments in a clustered column chart?
Hi guys, I have created a clusterd column chart with the departments on the Axis. The value of the clusterd column chart is a measure where I calculate the count of unique values in the column "Versies.Id" of the table "MKA", but only for those rows where the column "VullingProductTbbRubricering hh" is not blank. The measure is: ALLE-GII = CALCULATE( DISTINCTCOUNT(MKA[Versies.Id]), MKA[VullingProductTbbRubricering hh] <> BLANK() ) What I want now is that the total result of the measure "ALLE-GII" will be added only to one department "GII" and will not split over alle the different department. How can I do that? See picture below for how the column chart is looking right now.Ignoring a visual level Measure Filter, but keeping the slicer selection
Hello community! First time posting here, so please do not hesitate to ask if you need more details. The Report context The basic premise of the report is that the user can use a few slicers to select a portion of the company's products (Category, Sub-Category, Segment and Trend) and a slicer for the time period (usually current week -1 and the same period the previous year) The user then gets 2 tables: The first one shows the total results for the selection made using the slicers by year The second table shows the top 10 selling items for each year. This particular table is also filtered through the slicer pannel by using a ranking DAX measure (with value lower or equal to 10) The Problem In my Top10 table, I want to add a contribution% column which would do the following calculation: Sales of item / Sales of total selection For example (see capture of report): Sales of item A (137,578$) / Sales of the selection for 2023(1,851,206$) No matter what way I turn the formula, I cannot seem to be able to avoid the visual level filter on the Ranking Measure, so my denominator tops out at 539,128 (total of top 10 for 2023) instead of getting the 1,851,206 (total of the selection for 2023) Also important to note: My model is in Live Connect - so I cannot create a column in the model From what I've gathered, the ideal is to create a virtual table as a variable and then run a SUMX on it. Something like this: DENOMINATOR - Sales of selection = VAR tabletopstyles = FILTER ( KEEPFILTERS ( SUMMARIZE ( ALL ( Items ), Items[Style Image], "Sales", [Sales], "Rank", [_Top by Sales] ) ), NOT ( ISBLANK ( [_Top by Sales] ) ) ) RETURN SUMX ( tabletopstyles, [Sales] ) But after testing: I cannot use REMOVEFILTERS as it will not take an expression as a second argument Using ALL takes away all my slicer filters AND my visual level measure filter Using ALLSELECTED keeps my slicer filters AND my visual level measure filter....HELP! Last note: I've been able to do the opposite, which is bring my Top10 sales total back into my Total for all selection table at the top. But that table does not have a visual level filter. The formula was the following Ctr% T10 - for sales = VAR tabletopstyles = FILTER( KEEPFILTERS( SUMMARIZE( Items, Items[Style Image], "Sales",[Sales], "Rank",[_Top by Sales] )), AND(NOT(ISBLANK([Sales])), [_Top by Sales] <= 10)) RETURN DIVIDE(SUMX(tabletopstyles,[Sales]), [Sales]) Ideas on alternatives are also welcome!
