Solved: Display Region with Calculated Column Result

Anonymous · ‎12-20-2018

Hello Community,

How can I display below in Power BI Report?

Region	Sales Total
Asia	Calculated Column 1 Result
Europe	Calculated Column 2 Result
Americas	Calculated Column 3 Result
Australia	Calculated Column 4 Result

Does any one has any suggestions?

Thanks

v-chuncz-msft · ‎12-25-2018

@Anonymous,

You may also check Unpivot Columns in Query Editor.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-chuncz-msft · ‎12-25-2018

@Anonymous,

You may also check Unpivot Columns in Query Editor.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Greg_Deckler · ‎12-20-2018

Probably by using a SWITCH statement based on [Region] but tough to say exactly given the information. 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

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Display Region with Calculated Column Result

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024

How to Get Your Question Answered Quickly