Forum Discussion
Dax for Conditional PIVOT Table
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
2 Replies
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-Forum/ba-p/963216
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/1447523Hi 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
