Latest Enterprise DNA Initiatives


Slicing measure results based on a measure - filtered measure?

Hello Enterprize DNA Forum (annd @Greg)

This is a slightly different query to a previous query - link below:

https://forum.enterprisedna.co/t/calculating-whether-date-range-is-in-q1-q2-q3-q4-or-multiple-quarters/28484/2?u=natty

In this query I asked how to group assignments based on whether they were within a date range. @Greg - thank you for your response.

I’m wondering if there is a way that I can slice my results based on the IN RANGE measure - therefore if I select a Quarter, the results and % measures will only display if they are in that date range?

The image above displays dummy data of the measures, is there a way to filter / slice all these measures by the IN RANGE measure

IN RANGE Sceanrios:

  • the assignment start date is in the selected quarter(s)
  • the assignment end date is in the selected quarter(s)
  • both the assignment start date and end date are in the selected quarter(s)
  • the assignment start date is before the start of the selected quarter(s) and the assignment end date is after the start of the selected quarter(s)
In Range = 
SWITCH( TRUE(),
    [Start in Range] = 1, 1,
    [End in Range] = 1, 1,
    [Both in Range] = 1, 1,
    [Both span Range] = 1, 1,
    0
)

I’ve been seraching dynamic slicers, SELECTEDVALUES, FILTERS etc… and I cant seem to get the correct results. Is this even possible?

Any assitance or advice to point me in the right direction would be fantastic. Or if this is not possible please let me know and I will need to rethink how to slice the data…

eDNA Forum - Quarters_v2.pbix (5.9 MB)

THANK YOU :grinning:

Natty

Hi @Natty! We noticed that your inquiry was left unsolved for quite some time now.

Looks like your inquiry was out of the experts and users’ bounds.

We strive to answer ALL inquiries in the forum. However, if you are sure that you provided all pertinent context to your concerns and read how to use the forum more effectively and still find your question unanswered, you can check out tutorials to learn this yourself as your membership also comes with relevant resources that may help you with your Power BI education.

While our users and experts do as much as reasonable to help you with your inquiries, not all concerns can be attended to especially if there are some learnings to be done. Thank you!