undefined

Question

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

amitchandak · Answer

Anonymous , The information you have provided is not making the problem clear to me. Can you please explain with an example. 
&nbsp;
You can add them in another measure
Measure 2 =sum(Table[Column1]) +[measure]Appreciate your Kudos.

anonymous · Answer

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 · Answer

Hi Anonymous&nbsp;,&nbsp;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.&nbsp;Best Regards,LiangIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-lianl-msft · Answer

Hi Anonymous&nbsp;,&nbsp;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&nbsp;Best Regards,LiangIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

undefined

4 Replies

Related content

undefined

undefined

undefined

undefined

undefined