Agreegate the table at each customer level

[Sriku]

Hi Team,

I have transcation level detail table. I want create and new table to agreegrate the avg or total sales and join to transcation table.

How to achieve this:

[harshnathani]

Hi @Sriku ,

Can you share the expected output.

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[amitchandak]

@Sriku , Not very clear. Can you share sample data and sample output in table format?

This seems like Matrix with stepped layout off- https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/

[Sriku]

[Greg_Deckler]

@Sriku - I'm not 100% on the requirement. Looks like a Matrix visualization. Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[Sriku]

[harshnathani]

Hi @Sriku ,

You need a measure

Average Quantity = AVERAGE('Table'[Quantity])

HLM = 

SWITCH(
TRUE(),
[Average Quantity] < 4 , "Low",

[Average Quantity] >=4 && [Average Quantity] > 8, "Medium",

"High"

)

Drag the customer name, Average measure and HLM measure in the visualization pane.

If this does not work, please share sample data in text format

Regards,

Harsh Nathani

[Sriku]

I am getting ""A circular Dependency was detected" error while creating a calculated column"

[harshnathani]

Hi @Sriku ,

You need to create a measure and not calculated column,

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[Sriku]

while creating measure/column/ I am not able to plot graph but when putin metric table it appear. How show the H/M/L in pie after doing average.

[harshnathani]

HI @Sriku ,

See if this helps you

https://www.youtube.com/watch?v=jLloQ_1KiGI

https://www.youtube.com/watch?v=djLX6IUWVwY

https://www.youtube.com/watch?v=cbxVCa5lAcw

https://www.tutorialgateway.org/create-groups-in-power-bi/

Regards,

Harsh Nathani