DAX - Dual Header in Matrix

[venug]

Hi All,

Recently i am facing one simple issue. Try to put dual header in matrix visual, by using DAX queries. i have done DAX formulas for that, but when i place Matrix header (Dimiension) , values (Measure) in matrix visual, it's not trigger. 

Please help on this issue. i am providing sample pbix here.

Thanks in advance.

Regards,

Venu

[v-deddai1-msft · Accepted solution]

Hi @venug ,

You need to create three new measures :

Sales1 = SUM(Orders[Sales])
Profit1 = SUM(Orders[Profit])
Discount1 = SUM(Orders[Discount])

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

Best Regards,

Dedmon Dai

[v-deddai1-msft]

Hi @venug ,

Would you please show us the expected output? I can't understand your reuqirement based on your sample data. Is it similiar to https://community.powerbi.com/t5/Desktop/Double-Heading-Matrix/td-p/309886?lightbox-message-images-3...?

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

Best Regards,

Dedmon Dai

[venug]

Hi @v-deddai1-msft ,

Thanks for reply, Yes i need the same output which you have shared with me. 

Please find below my desired output.

Regards,

Venu

[v-deddai1-msft]

Hi @venug ,

Would you please check the permission of your shared file? Or you can use onedrive for business.

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

Best Regards,

Dedmon Dai

[venug]

Hi @v-deddai1-msft ,

Thanks for respond on it. Sorry for inconvenience, Can you please try it now, i have change permision now. 

Thanks & Regards

Venu 

[venug]

Hi Everyone,

Please help on the below issue.

Thanks in advance.

Regards

Venu