Dax for Conditional PIVOT Table

[AlanP514]

Hi i am trying to achive a pivot table like this (Above Image)
So due to the requirment i created a table in power bi itself(attached down)

after i kept each fields in right place in the pivot table as like this(attached below)

Next i need return the required columns and measure from the right table so i need to take dimension columns from one table and measure from another table eg.

Region Name		From Branch Table
Zone		From Branch Table
Branch Name		From Branch Table
Territory Name		From Branch Table
# Enquries		Fact_POD Table
Documents Uploaded	DMS	Fact_POD Table
	Total	Fact_POD Table
# App Upload %		Fact_POD Table

so i created a measure using switch and seletedvalue like this 

after i added measure into the values field in the pivot table but i am getting this error

My Expectation is i need to return each mentioned dimension columns  and measures using dax

Appreciate Help On this 

[Anonymous]

Hi @AlanP514 ,

Any update on this? Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...