Forum Discussion

abehrmann's avatar
abehrmann
Helper II
7 years ago

Distinct count filtered Average

 I am looking to get an average of Days in ops based on distinct Request #   I tried : Ops Average Age = divide(sum(OfficeTrax[Days in OPS]),distinctcount(OfficeTrax[Request #]))   But it doesnt ...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi abehrmann

i am having trouble with the relationships on the page level filters

I don't know why you need to create relationships, could you tell more about this?

 

Additionally, please have a look at my analysis about your case->

With rafaelmpsantos's measure, you could create the desired table on a report by table visual

 

If you want to create a new table as your desired table, addition to create one in query editor, you could create a new table with DAX

Table = SUMMARIZE(Sheet1,Sheet1[request],Sheet1[days in ops])

 

Then add columns in the table visual, and right-click on the "days in ops" column in the Value field, select "average" 

 

 

Best Reagrds

Maggie

abehrmann's avatar
abehrmann
Helper II
7 years ago

v-juanli-msft the new table  worked for me to get accurate averages.  But now when i filter the rest of the data these averages do not interact with the rest of the page 

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    Hi abehrmann 

    I guess the original table has some relationship with other tables, you want your new table interact with with other tables too.

    Please show me some example of other tables and what you want to show in this new table when filter in another table.

     

    Best Regards

    Maggie