Forum Discussion

Meca2u's avatar
Meca2u
New Member
2 years ago
Solved

Tricky measure with dax

Hi I have the following table, with a filter on date at the top. I am trying to create a measure in Power BI Desktop called Denominator that will return something like this... So basic...
Need Help
  • Meca2u's avatar
    Meca2u
    2 years ago

    Thanks,

    Below the dax i was looking for....

     

    Denominator =
    var _min_period=
    MINX(
        FILTER(ALLSELECTED('Query1'),Query1[Country] = MAX(Query1[Country]) && Query1[State] = MAX(Query1[State]) && Query1[Colour] = MAX(Query1[Colour]) ),
        'Query1'[Period])

    var _min_value=
    MINX(
        FILTER(ALLSELECTED('Query1'),Query1[Country] = MAX(Query1[Country])  && Query1[State] = MAX(Query1[State]) && Query1[Colour] = MAX(Query1[Colour]) && Query1[Period]=_min_period),[Value])

    RETURN _min_value
Meca2u's avatar
Meca2u
New Member
2 years ago

Thanks,

Below the dax i was looking for....

 

Denominator =
var _min_period=
MINX(
    FILTER(ALLSELECTED('Query1'),Query1[Country] = MAX(Query1[Country]) && Query1[State] = MAX(Query1[State]) && Query1[Colour] = MAX(Query1[Colour]) ),
    'Query1'[Period])

var _min_value=
MINX(
    FILTER(ALLSELECTED('Query1'),Query1[Country] = MAX(Query1[Country])  && Query1[State] = MAX(Query1[State]) && Query1[Colour] = MAX(Query1[Colour]) && Query1[Period]=_min_period),[Value])

RETURN _min_value