Forum Discussion
Help with relationships | Power BI Desktop
Dear all, I hope you are doing well. 😀
I am relatively new to using Power BI and need some help. I have two tables as follows:
Here is my model as it is now:
Here is my dashboard as it is now:
I need to create a relationship between these two tables so that when I select, for example, a01 through a first slice, the correspondent card (blue card) shows me "hamburger" and "francesinha" as answers. In this example, the two slices are running independently.
Is it possible to do this? If yes, how can I do this?
This is an illustrative example since I can not put actual data in this forum.
I appreciate any help you can provide.
Hi carlos_ferreira ,
According to your description, here are my steps you can follow as a solution.
(1) My test data is the same as yours.
(2) We can create a measure.
Measure = LOOKUPVALUE('rep'[rep_descricao],'rep'[index_rep],MAX('medida'[rep_index]))(3)We can create a table and a measure.
Table = var _table=SUMMARIZE('medida','medida'[index_medida],'medida'[rep_index],"test",[Measure]) return ADDCOLUMNS(_table,"descricao",CONCATENATEX(FILTER(_table,[index_medida]=EARLIER('medida'[index_medida])),[test]," and "))des = CALCULATE(MAX('Table'[descricao]),FILTER(ALL('Table'),'Table'[index_medida]=SELECTEDVALUE('medida'[index_medida])))(4) Then the result is as follows.
If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
carlos_ferreira , as the two tables are joined , create a measure
M1 = countrows(medida)
and use that as visual level filter for medida_desc
For cards consider new card visual releases in Jun-2023
Power BI June 2023 Feature Summary release notes: https://powerbi.microsoft.com/en-us/blog/power-bi-june-2023-feature-summary/
Thanks, amitchandak . But, I think I did not capture your idea regarding the measure "M1 = countrows(medida)" - why medida? - and mainly regarding the "visual level filter for medida_desc". I never did this before 😒
So, can you show me how to do this in more detail? As I said before, I am new to Power BI.
Thanks one more time 👍
Hi, amitchandak. I created the measure and used it in the field of the card. However, only the counting was shown. I need the names, referring to the two lines that contain "a01", which are "hamburger" and "francesinha"
Thanks!
Hi carlos_ferreira ,
According to your description, here are my steps you can follow as a solution.
(1) My test data is the same as yours.
(2) We can create a measure.
Measure = LOOKUPVALUE('rep'[rep_descricao],'rep'[index_rep],MAX('medida'[rep_index]))(3)We can create a table and a measure.
Table = var _table=SUMMARIZE('medida','medida'[index_medida],'medida'[rep_index],"test",[Measure]) return ADDCOLUMNS(_table,"descricao",CONCATENATEX(FILTER(_table,[index_medida]=EARLIER('medida'[index_medida])),[test]," and "))des = CALCULATE(MAX('Table'[descricao]),FILTER(ALL('Table'),'Table'[index_medida]=SELECTEDVALUE('medida'[index_medida])))(4) Then the result is as follows.
If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
