undefined

[Anonymous]

How to merge both calculated column query and measure in one single query

[amitchandak]

@Anonymous , The information you have provided is not making the problem clear to me. Can you please explain with an example.

You can add them in another measure

Measure 2 =sum(Table[Column1]) +[measure]
Appreciate your Kudos.

[Anonymous]

In One table i have calculated column name as Satisfied% and another table i have one measure name as Goals

I want one bar graph in that i want to see 5 bars which as  5 latest satisified% weekly data and one bar was quarterly goals data total 6 bars in one visual

[V-lianl-msft]

Hi @Anonymous ,

You can also try creating a new table with the five names of the x-axis and the name of the measure.

Then create a measure like this:

Measure Value2 = 
var avg_ = CALCULATE(AVERAGE('Table'[Satisfied%]),FILTER('Table','Table'[date]=SELECTEDVALUE('Table (2)'[date])))
return SWITCH(
    SELECTEDVALUE('Table (2)'[date]),
    "wk1",avg_,
    "wk2",avg_,
    "wk3",avg_,
    "wk4",avg_,
    "wk5",avg_,
    "quarterly goals",[Measure]
)

Using the columns of the new table as the x-axis and measure as the value, you can get six bar graphs.

Sample .pbix

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

[V-lianl-msft]

Hi @Anonymous ,

I haven't used the visual you mentioned. You can try to find it in market place.

The alternative is to use these visuals and add measure as line values or analytics.

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