Count DOW and divide actual filter DOW

[PrizzC15]

Hi 

I need help as below question:

TIA

[v-jianboli-msft · Accepted solution]

Hi @PrizzC15 ,

If the average aggregation could't work, please try:

Sales A =
var _a = SUM('Table'[Person A])
var _b = COUNT('Table'[DOW])
return DIVIDE(_a,_b)

Sales B =
var _a = SUM('Table'[Person A])
var _b = COUNT('Table'[DOW])
return DIVIDE(_a,_b)

Best Regards,

Jianbo Li

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

[v-jianboli-msft]

Hi @PrizzC15 ,

Is that not the result you want? Or have I misunderstood?

If I misunderstood, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

Refer to:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

Best Regards,

Jianbo Li

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

[v-jianboli-msft]

Hi @PrizzC15 ,

Based on your description, I have created a simple sample:

You can achieve this by using the average aggregation directly:

Final output:

Best Regards,

Jianbo Li

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

[PrizzC15]

Hi, 

I trying to upload pbix but not able.

Herewith the details:

Hope you can helps with this.

[PrizzC15]

My result is difference:

Based on Oct number DOW 

Mon, Sat & Sun divide 5

Tue, Wed, Thu, Fri divide 4

For example: Total of Sales for Person A in Oct 2022 by DOW

Fri 1004 / 4 = 251

Mon 943 / 5 = 188.6

Because each month it's difference DOW count

eg. in Jan 2022 (Mon, Sat & Sun x 5 days), in Mar 2022 (Tue, Wed & Thu x 5 days)...etc..

[v-jianboli-msft]

Hi @PrizzC15 

Sorry for that the picture you provided is not very clear. Can you share a clearer picture or share more details to help us clarify your scenario?

Please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

Refer to:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

Best Regards,

Jianbo Li

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

[PrizzC15]

Thank you for your reply. I had replaced the picture. Feel free to clarify with me if any doubt of question.