Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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, Activation, Media). I have already append the tables to be able to use one slicer for all Data.
Now, I want to create a measure, that shows me the ratio for each year for Fee & Activation +Media. (Ratio = (Activation+Media)/Fee). Unfortunately it does not work with the appended Table.
This is my measure:
It does not work only with the appended table. When try it with the table 2021 it works. the Problem is, that I want to create Dashboard with an Overview of all 3 years and would like to use only 1 slicer for all 3 years.
I hope someone can help me on that.
Thank you in advance and best regards,
Albert
Solved! Go to Solution.
No ideas? 😃
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.
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.
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.
Thank you @amitchandak and @Anonymous for the quick reply.
I have created a simple sample data but I dont know how to upload it here. So I put it into Dropbox.
Excel-Table:
Power bi:
https://www.dropbox.com/s/k6eduwh5qgr72ud/Power%20Bi%20appended%20Tables%20Issue.pbix?dl=0
I hope that will work.
These are the details of the error:
Thank you 🙂
The most important thing to be able to troubleshoot this... has not been shown. Click on the "See details" link and show us what the problem is. Thanks. Also, I immediately notice that your measures are tied to one specific year (2021). Not the best way to code a measure that should respond dynamically to selections in dimensions...
@Anonymous , can you share what is there in see details. On error
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |