How to Return Column text based on Filters

[Stuznet]

I want to know how to return column name/text  based on filters. 

I'm looking for the ProjectACT return with name filtered by Data=March, Start Year= 2018 and Start Month = Apr

 

I've tried this formula but is returning only 1 value

Column = CALCULATE(FIRSTNONBLANK(Data[ProjAct],TRUE()),FILTER(Data,Data[Start Year] = "2018"),FILTER(Data,Data[Start Month] = "April"),FILTER(Data,Data[Data] = "March"))

Can someone please help?

Thank you 🙂 

[dobregon]

Hi

Instead of using the comand FILTER that takes all the values in your import query, use the comand ALLSELECTED that analyse only between the filters you selected in your visuals.

[Stuznet]

I was able to get all the value but the last filter by Data[Data] doesnt seems to be working. I' getting different count 1314 instead of 257

April Plan Start = CALCULATE(FIRSTNONBLANK(Data[ProjAct],True()),
FILTER(Data,Data[Start Year] = "2018"),FILTER(Data,Data[Start Month] = "April"),
FILTER(Data,Data[Data] = "March" 
&& Data[ProjAct] = EARLIEST(Data[ProjAct])))

@dobregonCan you demonstrate? I am clueless what you mean by that.

[dobregon]

Maybe it will be easy if you can share the data and a demostration of final result that you need to have in order to give you a better example.

I think now with your last reply you can't use the allselected but, i can't understad now your point if i dont have an example of data source and a demostration in excel of the final value that you want.

[Stuznet]

I'm sorry for the confusion.

Below is the data from Excel. So basically what I want is the ProjAct column that is filter by Data = March, Start Year = 2018, Start Month = April. 

Data	Start year	Start Month	ProjAct
March	2017	June	140609F01140609F01I096
April	2018	March	140618T01140618T01I045
March	2017	Apr	140618T01140618T01I096
May	2018	July	140620U01140620U01I045
June	2018	August	140908A01140908A01I045
April	2018	April	141210A18141210A18I045

[dobregon · Accepted solution]

Hi,

I have done the measure 

Projectmeasure = CALCULATE(MAX(Table1[ProjAct]),
    FILTER(Table1,
        Table1[Data]="March"
        &&
        Table1[Start year]=2018
        &&
        Table1[Start Month]="April"
    ))

but in your data source you have a problem becasue it doesn't exist a projectAct related to the filters that you want

If you check value March in column Data, there is only one start year (2017) so, there isn't exist startyear 2018 for a data March

[Stuznet]

@dobregonthank you so much for your help. But is close enough to the result I wanted. Your formula does work 🙂 

[dobregon]

you're welcome!