topic Re: Dynamic Measure calculation in Developer

Dynamic Measure calculation

NMDGA — Tue, 20 Aug 2024 16:14:36 GMT

Hi team ,

i am learning powerbi dax and i am facing difficulty in designing an approach for this implementation:
i have a table with report date , product, activeflag and amount . When i select a date value from report date which is used as slicer i want to get all the rows displayed in a table visual which are tagged to the selected date + the rows that have date < selected date but with active flag ='Y' . Eg . If i have selected 2 aug in my slicer i should display all records belonging to 2 aug + plus active rows from 1 aug and 31 july + 30 july etc . If i select 1 aug in slicer i should be displaying all rows from 1 aug plus only active rows from 31 july , 30 july etc .

Re: Dynamic Measure calculation

lbendlin — Wed, 21 Aug 2024 00:49:49 GMT

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: Dynamic Measure calculation

Anonymous — Wed, 21 Aug 2024 06:17:22 GMT

lbendlin , thanks for your concern about this case. I tried to create a sample data myself based on the user's requirement and implemented the result. Please check if there is anything that can be improved. Here is my solution:
Hi @NMDGA ,

I created some data:

Here are the steps you can follow：

When the same columns are used in the slicer and the table visual, then the table visual will change with the values selected by the slicer, and we can create a table of dates with no relationship to work with measure

1. Create calculated table.

Date = CALENDAR( DATE(2024,7,1), DATE(2024,10,31))

2. Create measure.

Flag = var _select=SELECTEDVALUE('Date'[Date]) return IF( MAX('Table'[report date])=_select || AND( MAX('Table'[report date])<_select,MAX('Table'[activeflag])="Y"),1,0)

3. Place [Flag]in Filters, set is=1, apply filter.

4. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly