Filtering a table using TOP N slicer
Hi, i have a TOP N slicer which is a what if parameter from 0 to 50, i am trying to filter TOP N qty for a product in a table. please note there is already a TOPN filter on week for the table visual like pic below, so another topn is not possible and the data does not have an id/unique column and the products are repeted several times and the week in the sample is different from the topn loaddateweek. I am using a DAX measure to calculate the top products TOP N measure = VAR SelectedTop = SELECTEDVALUE('TOPN'[TOPN]) RETURN SWITCH(TRUE(), SelectedTop = 0, [Still to supply_sum], RANKX( ALLSELECTED(table[week],table[Product]), [Still to supply_sum], ,DESC,Dense ) <= SelectedTop, [Still to supply_sum] ) but this is not filtering for only 1 value when top n filter selected =1, but shows multiple value. Sample data is like below: Week Product Still to supply_sum rank 2024 34 6708 58720 1 2024 40 7706 64919 1 2024 38 6708 48120 2 2024 40 6708 43040 2 2024 38 731 34400 3 2024 36 6708 33560 3 2024 39 7448 36000 3 2024 41 6961 32040 5 2024 38 300 30080 6 2024 36 300 28120 7 2024 30 7551 24720 9 2024 41 122116010 22160 10 2024 36 731 21560 11 2024 41 7551 19790 15 2024 32 7551 19168 17 2024 31 300 16204 24 2024 32 300 15669 25 Not sure how to solve this issue to just have rank that does not repeat for a another row for the same product. Thanks for the help in advance.
Rolling Sum for a subset of data
Hi Everybody, I am struggling with a DAX Formula: Calculation works for the overall time range, as you can see in the table, but it doesn't work for specified time range (15th to 23rd ). The rolling sum for this time range should start with 0 instead of 1 This is my DAX Formula: Cumulative Rolling Sum Value_B = CALCULATE( SUM('Sheet1'[Value_B]), FILTER( ALL('Sheet1'), 'Sheet1'[Date] <= MAX('Sheet1'[Date]) ) ) Any ideas what I am doing wrong ?
Dynamic table
Hello, I'm trying to create a dynamic table in Power BI. I'll give the context: I have an Excel file with several data tables. I have a Power BI dashboard with a visual Filter and each filter corresponds to a table in the Excel file. I would like the table to change depending on the filter selected, taking the right data from the right table in the Excel file (depending on the filter selected on the visual, the table should take the right table and display the right data on the report). My idea: I thought of creating a calculated table with a formula that would say: "If on visual X, filter Y is selected then my table is T1 otherwise my table is T2." Something like that. In my idea, I need to specify exactly which visual it is, either with the exact name of the visual, or with a unique id. If this is not possible, can you suggest an alternative solution? Thanks in advanceTotalYTD or DatesYTD based on SLicer filter
Hello everyone, I have a totalytd measure, and creating a bar chart based on date and total sales. Also I have a slicer which contains Month Name. If I filter for March month, the bar chart will show data only for March month but my requirement should be like the visual should display till March month (Jan, Feb and Mar). Likewise if I select June month in the slicer, the bar chart should display data from January to June. How to achieve this, please advice.
Measure Should populate ID row in Matrix
Good morning I have a matrix visual with IDs on the row Level from 'DIM Emp'[EmpID] I would like to create a measure that populates the row of certain ids. In this case IDs 5 & 6 should be populated with the result of the 1st part of the measure, the rest with the 2nd part Something along the lines of Emp = IF ( MAX ( 'DIM Emp'[EmpID]) IN { 5 , 6} CALCULATE ( SUM ( 'HC'[Amount] ), KEEPFILTERS ( 'DIM Emp'[EmpID] IN { 2, 3, 4 } ) ) - CALCULATE ( SUM ( 'HC'[Amount] ), KEEPFILTERS ( 'DIM Emp'[EmpID] = 7 ) ) , CALCULATE ( SUM ( 'HC'[Amount]), KEEPFILTERS ( 'DIM Emp'[EmpID] IN { 11, 10, 12 } ))) Thanks
