Forum Discussion

Shamatix's avatar
Shamatix
Icon for Post Partisan rankPost Partisan
9 years ago

DAX: Measure, a single value for column in table cannot be determined

Hey fellow users of power bi,

 

I figured out my first issue but now I have a second issue:P

I have 3 tables and 2 bridge tables, table A,B and C and Bridge D and E

 

Table A has a relation ship to table B using a bridge table D and Table B has a relation ship to C with using a bridgetable E.

I am trying to create a mesure in table A and I need values frmo table E, how does one do this?

 

 

Best regards

Need Help

7 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    9 years ago

    Not much to go on here but generally you use something like RELATED or RELATEDTABLE in a measure calculation. Sample data would allow us to recreate it and provide a more useful response.

    • Shamatix's avatar
      Shamatix
      Icon for Post Partisan rankPost Partisan
      9 years ago

      Thanks, I actually managed to figure out with some help^^ Got a 3 new questions for ya tho:P

       

      If I have a measure which uses average and is working great and as intended, is it possible to have the SUM shown at the bottom instead of the average in those bold numbers of the table?

       

       

      Second question is the following: How can I easily create a slicer with following values:
      January - February
      March - April
      May - June
      Juli - August
      September - October
      November - December

       

      So there is 2x months in each "select", I have found a solution but it involves creating 2x dublicates of my date column, one where I transform the date name and replace january with January - February and february with January - February etc etc and then the second column I transform into month ID so I can sort it correctly, but then I also have to replace month id 2 with 1 month id 4 with 3 etc etc and this isnt a pretty solution in my eyes, but it works.

       

      Last question is:
      I have a table and I want to add a new column with URLs to files on the computer, I have the fileNAME in another column and all the files are in the same directory, so somehow I have to make a custom column as a URL where it takes a value from another field and comebines it with the URL, is this possible and if so how?

      • v-qiuyu-msft's avatar
        v-qiuyu-msft
        Icon for Community Support rankCommunity Support
        9 years ago

        Hi Shamatix,

         

        1. As the measure use the Average() aggregation, the total row in the same table visual cna't be set to use SUM aggregation. The work around is to create a measure return the SUM value then place it in another visual, and place those two visuals stay together.

         

        2. You can try the Timeline slicer visual.

         

        3. Assume URL and directory are stored in two columns, you can use CONCATENATE() function to combine those two columns.

         

        Best Regards,
        Qiuyun Yu