Multi-Row Card Display Help

[Anonymous]

I have a two-part issue. I am using two cards, connected to a filter, to display data on my dashboard. One card is a single row while the other is a multi-row. When no selection is made, I am using the following formula to ensure the card comes up blank:

IF(ISFILTERED(Personnel [NAME]),MAX(Lang[TYPE]),Blank()&””)

This works for both cards; however, when a selection is made for the multi-row card, only one result is returned as opposed to all possible values. I am sure that this is because of the MAX portion of the formula, however, I do not know what I should be using instead.

For the second portion of this equation, I have a single card that is supposed to return the date an individual started working; however, with the MAX portion of the formula above, it returns 12/31/2020 for the max date as opposed to the correct date the individual started.

Can anyone help me with these two issues? How to return all possible results for the multi-row card, and how to return the correct start date for individuals.

[amitchandak]

@Anonymous ,Can you share sample data and sample output in table format?  and explain the output with sample data

[Anonymous]

Good morning. Do you think you could help me find a solution to my problem?

[Anonymous]

Unfortunately, I don't have access to BI right now, but I attempted to make an excel example of what I mean. Both tables are connected via the personnel number and when a name is filtered, the text boxes to the right of the tables displays what I need to see. As I mentioned though, I am not seeing the right date, or the multiple selections for the multi-row card. I hope this helps!  

[Pragati11]

Hi @Anonymous ,

1. What is the format of your date column that you are displaying on a single card?
2. for the multi-row card, I think you are using Language column, which can have multiple values against a Person.
   • What is the relationship between these two tables?
   • On which column the relationsip is made?
   • What is the direction of the relationship?

Thanks,

Pragati

[Anonymous]

Hi, @Pragati11 , 

Thank you for the reply. 

1) The date format is MM/DD/YYYY

2) You are correct, I am using the language column and there are multiple values for each individual. 

• The relationship is many-to-one (*:1)
• The relationship is made via the person ID column 
• It is a single direction between the tables

[Pragati11]

Hi @Anonymous ,

I think I need to see your Power BI file, in order to check the issue.

Can you share .pbix file?

Thanks,

Pragati

[Anonymous]

I don't at this time, but I will try to recreate the issue and post it here. Thank you. 

[Pragati11]

HI @Anonymous ,

Do you mean you don't this issue anymore on your report?