Forum Discussion

niceday123's avatar
niceday123
Frequent Visitor
6 years ago
Solved

Display data + measure in the same vizualisation

Hi,   I have the following data :   Table1 : Forecast Table2 : Objective I'd like my vizualisation to show that :   Any help will be very much appreciated. Many thanks.
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi niceday123 ,

     

    Measure = 
var a = CALCULATE(SUM(Objective[Sales Objective]),FILTER(Objective,Objective[Name]=SELECTEDVALUE(Forecast[Name])))
var b = CALCULATE(SUM(Forecast[Sales Forecast]),ALLEXCEPT(Forecast,Forecast[Name],Forecast[Place],Forecast[Month]))
return
a-b

    Can't hide but you can change the font color to white under Format -> Field formatting

     

    Best Regards,

    Jay

    Community Support Team _ Jay Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

niceday123's avatar
niceday123
Frequent Visitor
6 years ago

Hi Anonymous , Thanks for your answer.

 

Could you please share the DAX formula of your measure 3 ?

 

Also, is there a way to ignore/hide details by Place only for columns Measures 3 and display total of that column as the sum of the subtotal ? i.e. :

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi niceday123 ,

 

Measure = 
var a = CALCULATE(SUM(Objective[Sales Objective]),FILTER(Objective,Objective[Name]=SELECTEDVALUE(Forecast[Name])))
var b = CALCULATE(SUM(Forecast[Sales Forecast]),ALLEXCEPT(Forecast,Forecast[Name],Forecast[Place],Forecast[Month]))
return
a-b

Can't hide but you can change the font color to white under Format -> Field formatting

 

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • niceday123's avatar
    niceday123
    Frequent Visitor
    6 years ago

    Hi Anonymous ,

     

    Thank you, very helpful !

    My last concern is about the total of the column measure which I would like to show the sum of the bold values in the column (i.e. in Jan : 0 + (-1000) + 1000 = 0 )

     

    Thanks