Forum Discussion

palvarez83's avatar
palvarez83
Helper I
7 years ago
Solved

Help with dax filter function using measures as arguments.

Hello, I was hoping someone can help me figure out my syntax problem.  I have two tables disCalendar and fCommTime which are not relate.  My disCalendar table has 3 useful columns I am trying to use...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi palvarez83

     

    You may refer to below measure:

    NextWkdyProd =
CALCULATE (
    SUM ( dCalendar[Productivity] ),
    FILTER (
        dCalendar,
        dCalendar[Date]
            = MINX (
                FILTER ( dCalendar, dCalendar[Date] > [End date] && dCalendar[Workday] = 1 ),
                dCalendar[Date]
            )
    )
)

    Regards,

    Cherie

JoeRobert06's avatar
JoeRobert06
Helper II
7 years ago

I am having the same issue here, trying to make the filter context for a DAX table to be dynamce with either a slicer selection or a measure; see my below post as a reference. It looks like the method below is to wrap the argument with another filter() and then iterate across that table inside the original filter argument. I will try to see if solves my problem.

 

palvarez83, did this solve your problem?

 

Edit: I fogot to link my post, see below

 

https://community.powerbi.com/t5/Desktop/Dynamic-filter-argument-within-table-expression/m-p/630026

palvarez83's avatar
palvarez83
Helper I
7 years ago
JoeRobert06 wrote:

I am having the same issue here, trying to make the filter context for a DAX table to be dynamce with either a slicer selection or a measure; see my below post as a reference. It looks like the method below is to wrap the argument with another filter() and then iterate across that table inside the original filter argument. I will try to see if solves my problem.

 

palvarez83, did this solve your problem?

Hi Joe,

I did eventually solve a similar issue.  Apparently I was running into the "implied calculate" issue with my measure.  How I solved it was when the measure was defined, in the calculate with fillter, I enclosed the tabled name with ALL().  This thread show how I did something similar.

https://community.powerbi.com/t5/Desktop/Lookup-DateKey-from-another-column-s-running-total/m-p/588868#M279273