Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

DAX Help

Hi, Need some help with DAX. I have data something like below (second screenshot). Total Current Hours and 'Measure3' are the 2 metrics. Total current hours has data for multiple regions (column3) ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi,

This is confidential data and I am afraid I won't be able to share the file with you. Any thing else can help you understand the data?

 

jdbuchanan71's avatar
jdbuchanan71
Super User
7 years ago

The only other thing I can think to do is add a realationship between the two tables but set it to INACTIVE and use it in your measure.  Something like.

Measure3 =
CALCULATE (
    [Total Mission Hours],
    FILTER (
        Fact_Mission_Hours,
        Fact_Mission_Hours[Region Name]
            = SELECTEDVALUE ( 'Dim_Region (2)'[Region Name DB] )
    ),
    USERELATIONSHIP ( 'Dim_Region (2)'[Region Name DB], 'Fact Current Hours'[Column 3] )
)