Forum Discussion

mp390988's avatar
mp390988
Post Partisan
1 year ago
Solved

Using LookUpValue inside a measure

Hello, I have this below:   I want to add a column that shows the targets for each dealer group for each month. I already created a summarised table as per below that groups the targe...
Need Help
  • FBergamaschi's avatar
    FBergamaschi
    1 year ago

    At the total the SELECTEDVALUE call provides a blank value

     

    probably the solution is

     

    SUMX ( 
            SUMMARIZE ( 
                      RevenuesTargetsSummarised,
                      RevenueTargetsSummarised[DealerGroup],
                      CalendarTbl[Month]
            ),

              LOOKUPVALUE(
                     RevenueTargetsSummarised[MonthlyTargets],
                     RevenueTargetsSummarised[DealerGroup], SELECTEDVALUE(TradesTbl[DealerGroup]),
                     RevenueTargetsSummarised[Month], SELECTEDVALUE(CalendarTbl[Month])
              )

    )

     

    If this helped, please consider giving kudos and mark as a solution

    me in replies or I'll lose your thread

    Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

    Consider voting this Power BI idea

    Francesco Bergamaschi

    MBA, M.Eng, M.Econ, Professor of BI

     

mp390988's avatar
mp390988
Post Partisan
1 year ago

So I managed to get my lookupvalue function working in my measure but my issue now is that I need to somehow display the sum in the yellow marked section.

 

 

How can I acheive this in the measure definition.

FBergamaschi's avatar
FBergamaschi
Super User
1 year ago

At the total the SELECTEDVALUE call provides a blank value

 

probably the solution is

 

SUMX ( 
        SUMMARIZE ( 
                  RevenuesTargetsSummarised,
                  RevenueTargetsSummarised[DealerGroup],
                  CalendarTbl[Month]
        ),

          LOOKUPVALUE(
                 RevenueTargetsSummarised[MonthlyTargets],
                 RevenueTargetsSummarised[DealerGroup], SELECTEDVALUE(TradesTbl[DealerGroup]),
                 RevenueTargetsSummarised[Month], SELECTEDVALUE(CalendarTbl[Month])
          )

)

 

If this helped, please consider giving kudos and mark as a solution

me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI