Forum Discussion

KNP's avatar
KNP
Super User
4 years ago

Measure with Disconnected Table as Filter

TLDR I suspect this will be easy for someone with a better understanding of DAX (currently my weakest skill set, work in progress) and that hasn't been staring at the problem for hours.   This ...
Need Help
parry2k's avatar
parry2k
Super User
4 years ago

KNP try this measure, let me know if it works, I guess you want to iterate over each unique row based on GNA_ORG_NAME & LAV_LVE_TYPE  to get the Total Days:

Leave Summary sample data you provided is not good enough to produce the issue because each row in the sample data is unique.

LeaveSummaryDaysDynamic = 

    SUMX ( 
        SUMMARIZE ( 
            LeaveSummary,LeaveSummary[GNA_ORG_NAME],LeaveSummary[LAC_LVE_TYPE], "@LeaveSummaryDays", [Leave Summary Days] 
        ),
        IF ( 
            [@LeaveSummaryDays] >= MIN ( DaysGroup[MinValue] ) && 
            [@LeaveSummaryDays] < MAX ( DaysGroup[MaxValue] ), 
            [@LeaveSummaryDays] 
        )
    )

 

 

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.


 

KNP's avatar
KNP
Super User
4 years ago

parry2k - Your assumptions are correct. I was hopeful when I saw your measure but unfortunately it is still returning incorrect numbers. I would be suprised if the actual table rows weren't unique. 

I can't get my head around why the total in the >100 days is so high (and wrong).