topic Convert a DAX measure in DAX Commands and Tips

Convert a DAX measure

mwolfc — Wed, 20 Sep 2023 21:22:45 GMT

Hello, well, after 4 hours of research and Chat GPT, it's time to ask my Forum friends!

Question: I have a DAX measure which I'm using in a card visual, which gives a count of records, and it works great.

<CountWalksInPreviousWeek =

CALCULATE(

COUNTROWS('Booked Sales'),

FILTER(

'Booked Sales',

'Booked Sales'[QW Date] >= (TODAY() - WEEKDAY(TODAY(), 2) - 6) && 'Booked Sales'[QW Date] <= (TODAY() - WEEKDAY(TODAY(), 2))

)

It counts the number of rows containing QW Dates occuring over the previous Mon-Sun period.

Now, for a drill-own visual I want to modify this measure into a new measure that will list out these filtered dates, and also list 2 other fields with values from those rows. The new field names are "Job Name" and "Customer". Everything I have tried today has failed me. Thanks so much!

Re: Convert a DAX measure

some_bih — Thu, 21 Sep 2023 12:26:55 GMT

Hi mwolfc you already have rows, if your measure works as expected 🙂

In your measure, filter part will give your "rows"

Put this into calculated table and you will have it.

FILTER(
'Booked Sales',
'Booked Sales'[QW Date] >= (TODAY() - WEEKDAY(TODAY(), 2) - 6) && 'Booked Sales'[QW Date] <= (TODAY() - WEEKDAY(TODAY(), 2))
)

Did I answer your question? Kudos appreciated / accept solution!

Re: Convert a DAX measure

mwolfc — Thu, 21 Sep 2023 13:23:21 GMT

Thank you so much for the suggestion! I simply dragged that measure into the drill-down report and it worked perfectly!