Forum Discussion

mcray11's avatar
mcray11
Icon for Helper I rankHelper I
10 years ago

Help with a table visualization/DAX Query

Hi All- I'm not every experienced with Bi and am hoping someone can help me create a useful table visualization.  I have a set of data across a few tables, and I'm trying to display the per month s...
Need Help
v-haibl-msft's avatar
v-haibl-msft
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

mcray11

 

Could you please provide the relationship of these tables? And the answers to CahabaData’s questions are also needed.

 

Best Regards,

Herbert

mcray11's avatar
mcray11
Icon for Helper I rankHelper I
10 years ago

Hi Herbert,

 

There are two intermediatry tables connecting the two data sources for this visualization. 

Site>Locations>Order Numbers>Val in RC data

 

Thanks for any suggestions!

  • v-haibl-msft's avatar
    v-haibl-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    10 years ago

    mcray11

     

    If Val in RC is not a calculated column, we should be able to get the desired result with setting TOTAL_VEHICLES and TOTAL_SERVICES to SUM and Val in RC to Don’t summarize as below.

     

     

    Best Regards,

    Herbert