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
pratyashasamal's avatar
pratyashasamal
Icon for Memorable Member rankMemorable Member
2 years ago

Hi Meca2u ,

You can this calculation :-

Column = CALCULATE(MIN(Table1[Value]),FILTER(Table1,Table1[Country]=EARLIER(Table1[Country]) && Table1[State] =EARLIER(Table1[State]) && Table1[Color] =EARLIER(Table1[Color]))))

Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C