Forum Discussion

joseph-ryu's avatar
joseph-ryu
New Member
9 years ago

Measure filtering with ONLY date

Hi All,

 

I am working on a power bi report to show the Servers' performance against the Restaurant's performance. 

 

I have two main tables: feedback and server

feedback and server tables have cross filter direction of "both"

 

I have a chart for the names and their served counts and the user can click the servers and the report should change appropriately.

 

I have 2 main measures: performance indicator for the restaurant and server

 

I would like to create a Restaurant Performance measure that is ONLY filtered by the time slicer(Timeline), AND does not drill down when I click the name of the servers. I have the following code but it seems my number is off somehow. Any ideas?

 

_MEASURE_CSI_TABLETALK = CALCULATE(SUMX(Feedback, [TotalFeedback] * [AverageRating]), ALLEXCEPT(servers, servers[AverageRating])) / CALCULATE(SUM(Feedback[TotalFeedback]), ALLEXCEPT(servers, servers[ServedCount]))

1 Reply