Unable to Use New Reporting Header Column in Table Visual

[Anonymous]

Hi Experts 

Kindly refer to table Logistics, and refer to Calculated Column New_Reporting_Headers which has been created by combine what is in Reporting Headers. I am getting Correct figure i my table but i want to show data using "New_Reporting_Headers". When i remove Reporting Headers the values are not show.....

Sample File Link

https://www.dropbox.com/s/npy2jxnen9l7ig7/PLP_Test_2.pbix?dl=0 

[lbendlin]

Please reduce your wall of code to the essence of your issue. Strip out everything that is unrelated to the issue. That will make it easier for other forum users to help you.

[lbendlin]

Remember that measures are calculated for EVERY cell of your visual, including row and column totals and the grand total. Worst case you have to handle four different scenarios in your measure calculation. Recommendation is to start from the perspective of the grand total.  (Hint: Grand Total has no idea what "Selectedvalue" means.)

[Anonymous]

I don't now the answer hence why am asking.

[lbendlin]

Your measure is wrong. Remove the measure and all categories reappear.

You can't use SELECTEDVALUE like that in your measure.

[Anonymous]

Hi Ibendlin.

I know if I remove the measure the categories re appear- not sure on how to right the measure- kindly help please. And thanks for the feedback