Visual Help

[abhijsrwala]

I want to analyze this data other than a typical market basket analysis.What and how should I do that? Any suggestions?

[v-henryk-mstf · Accepted solution]

Hi @abhijsrwala ,

For different data models, you can combine the business requirements by creating different measure or calculated columns to achieve. For example, refer to the following test: results based on different groupings:

M_1 =
CALCULATE (
    SUM ( 'Table'[E] ),
    FILTER ( ALL ( 'Table' ), MAX ( 'Table'[Emp_id] ) = 'Table'[Emp_id] )
)

M_ = CALCULATE(SUM('Table'[E]),ALLEXCEPT('Table','Table'[Name]))

In addition, powerbi also provides many template examples for reference.

Tutorial: Explore a Power BI sample - Power BI | Microsoft Docs

If the problem is still not resolved, please point it out. Looking forward to your reply.

Best Regards,
Henry

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

[amitchandak]

@abhijsrwala , is this source format?

what is target/output format