Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
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!
Proud to be a Super User!
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!
Proud to be a Super User!
Thank you so much for the suggestion! I simply dragged that measure into the drill-down report and it worked perfectly!
User | Count |
---|---|
50 | |
23 | |
18 | |
18 | |
14 |
User | Count |
---|---|
91 | |
84 | |
43 | |
26 | |
21 |