Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Measure for merged (append) Tables

Hello,   I was wondering if someone could help with my problem.   I have 3 Tables. Each Table relates to another year(2019,2020,2021). Each Table has the 5 coloumns (Country, Year, Fee, Activatio...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    No ideas? 😃

Anonymous's avatar
Anonymous
Not applicable
5 years ago

It's clear from the description of the error that you're using a table with at least 2 entries where the code expects one value or a table with just one entry (these are equivalent in DAX). Please show the code of the measure. Very often people code and their assumption about what the code does is incorrect. This is what's just happened to you.

 

I can't use Dropbox from work. Sorry.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    please see below the appended table. 

     Here is the code, i think from the appended table:

     

    I don´t know how to see the code of the measure. I created the measure by choosing the button "new measure" and put this formula: 

     

    Sorry, I dont know how show you the Dax code of the measure.

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    I also tried to creat a coloumn, to calculate the ratio for each ratio. The problem is, if I choose the arithmetic value, it shows me a wrong number, beause not every asset has values.