Forum Discussion
relationship between two tables (Parameter)
Hello, I created a Parameter (Generateseries(0;20;1) to creat a slicer where I can chose between Top 1-20 of Expenses. Below you can see the code for the measure: The Slicer and the...
amitchandak
Super User
Super UserAnonymous , unless you use what id parameter or generate series in the formula it will not work or my give cartesian.
Can you share sample data and sample output.
Or try:https://docs.microsoft.com/en-us/dax/treatas-function
Hi amitchandak,
thank you.
A stupid question: How can I share my Data here? I cant find any attachments or should I create a table here?
Thank you,
Albert
- amitchandak
Anonymous , Upload to One drive or drop box and share the link
Hi amitchandak ,
here the links to the Data and output:
https://www.dropbox.com/s/36ffax6vmi6ykwo/POWER%20BI%20Sample.pbix?dl=0
I hope you can open the link.
I just realized, that the total of my Top N is wrong. It shows me the total of all Assets not of the Top N.