Forum Discussion

Frequent Visitor

2 years ago

Filter column based on 2-value combination from another table

Hello, I have a table (Table1) with columns ID, Attribute, Value. This is a pivoted table of 200 columns and 3000 rows + an added index column. Some Attributes may have the same range of Values. V...

Anonymous

Not applicable

2 years ago

Can you provide detailed sample pbix file and the results you expect.So that I can help you better. Please remove any sensitive data in advance.

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Frequent Visitor

2 years ago

I made an example, but I have a stupid question.
How do I upload it ??
I am new to this forum.

foodd
Community Champion
2 years ago
You can upload the PBIX file to a cloud storage service such as OneDrive, Google Drive, Dropbox, or to a Github repository, and then share a file’s URL.

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523/highlight/true#M607150

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.
- simple_user
  Frequent Visitor
  2 years ago
  This works exactly how i want it to worlk:
  https://drive.google.com/file/d/1Ar4E-C12Dbc46Fpl26VaYqa3voEey-iR/view?usp=sharing
  for a short amount of lines .....
  from a slicer, i apply "and" logic and pass the selected ids into a string
  If I create a calculated column, i believe it would be static, but I want dynamic metrics. Hence I use measures
  can I replace the string "selected ids" with something else ??
  for big datasets the metrtics/visuals take up to 5 minutes to load