Forum Discussion

mcray11's avatar
mcray11
Helper I
9 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
Microsoft Employee
9 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
Helper I
9 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
    Microsoft Employee
    9 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