Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Unable to Use New Reporting Header Column in Table Visual

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 

Need Help

5 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    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's avatar
    lbendlin
    Super User
    5 years ago

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

     

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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 

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    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's avatar
      Anonymous
      Not applicable
      5 years ago

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