Set value based on row data

[naoki]

I would like to set value for all to be true if one of the rows contain a certain data.  Each line is a unique transaction which I would want to track different items, so I cannot merge it together, as I would be showing a breakdown of each line and hide only those that is blank and show only those that have transaction. 

So if ABC only have 1 line but does not have data on that column it will hide it in my report, and as XYZ has at least 1 line of data it should show all lines. 

Below table is the expected results 

Name	Sales	Results
ABC		False
XYZ	1	True
XYZ		True

[Anonymous · Accepted solution]

Hi @naoki 

Check the below code.

Results = IF(CALCUALTE(COUNT(table[names]),ALLEXCEPT(table,table[Names]),NOT(ISNULL(table[sales])) && table[sales]>0) > 0

                 , "True"

                 , "False")

[Greg_Deckler · Accepted solution]

@naoki - Perhaps

Results =
  VAR __Name = MAX('Table'[Name])
  VAR __Table = FILTER(ALL('Table'),[Name] = __Name && NOT(ISBLANK([Sales])))
RETURN
  IF(ISBLANK(__Table),0,1)

You can then filter on Results being 1 

[Anonymous · Accepted solution]

Hi @naoki 

Check the below code.

Results = IF(CALCUALTE(COUNT(table[names]),ALLEXCEPT(table,table[Names]),NOT(ISNULL(table[sales])) && table[sales]>0) > 0

                 , "True"

                 , "False")

[amitchandak]

@naoki , Not very clear assume sales ia measure,

if([sales] =0 || isblank([sales]), blank(),[sales])
if([sales] =0 || isblank([sales]), blank(),[sales])

Can you share sample data and sample output in table format

[naoki]

Hi @amitchandak  I am unable to share the data as it contains confidential information. But maybe you can see below table for better clarity.  Late payment column is a calculated column which has been done. What that I would like to do is scan each line of acct name and to show only acct name with at least 1 line of late payment. If an acct does not have a single late payment it should not be shown. Payment check should also be a calculated column to show the results

Assuming this is the data set.  

Name	Inv #	Inv Date	Sales	Customer paid Date	Late payment?	Payment Check
ABC	123	1st Mar 2020	10	3rd March 2020	No
XYZ	222	1st Apr 2020	100	1st July 2020	Yes	Late
XYZ	322	1st Aug 2020	100	3rd Aug 2020	Yes

This should be how the results be shown. Only Acct XYZ will be shown, as one line is late. This is needed as I want to see how many lines and the details of the late payment for secondary analysis. 

Name	Inv #	Inv Date	Sales	Customer paid Date	Late payment?	Payment Check
XYZ	222	1st Apr 2020	100	1st July 2020	Yes	Late
XYZ	322	1st Aug 2020	100	3rd Aug 2020	Yes