Filter to be automated on the basis of selection in the field

[ppriya]

Hi all,

Need to automate the Filter section in DAX on the basis of selection in a particular field.

You need to make the selection in Testaname field.

Below is the data Set

ID	Employee ID	Employee Name	Employee Status
1	E1	ABC	Active
2	E2	CEF	Active
3	E3	GHI	Active
4	E4	JKL	Inactive
5		MNO	Active
6	E6	PQR	Active
7	E7		Active
8	E8	VW	Active
9	E9	XY
10	E10	Z	Active

RowID	TestaName	Table Name	Field
1	Employee ID is Blank	Test Data	Employee ID
2	Employee Name is Blank	Test Data	Employee Name
3	Employee Status is Blank	Test Data	Employee Status

When i do any selection in TestaName field it should return me the count of blank of that particulate column in the 1st table 

Dax which i created and is not working

Project_Measure_testing =

VAR vTablename = SELECTEDVALUE(FA_DATA_MATURITY[TABLE_NAME])

VAR vFieldname = "Filter('"&SELECTEDVALUE(FA_DATA_MATURITY[TABLE_NAME])&"',isblank('"&SELECTEDVALUE(FA_DATA_MATURITY[TABLE_NAME])&"'["&SELECTEDVALUE(FA_DATA_MATURITY[FIELD_NAME])&"]))"

Return --Query

Calculate(count(LU_PROJECT[PROJECT_ID]),vFieldname)

Kindly help me with this.

Thanks !

[v-yadongf-msft]

Hi @ppriya ,

Field parameters are recomended.

Please create three measures:

Employee ID is Blank = CALCULATE(COUNT('Table'[Employee ID]),FILTER('Table','Table'[Employee ID] = BLANK()))

Employee Name is Blank = CALCULATE(COUNT('Table'[Employee Name]),FILTER('Table','Table'[Employee Name] = BLANK()))

Employee Status is Blank = CALCULATE(COUNT('Table'[Employee Status]),FILTER('Table','Table'[Employee Status] = BLANK()))

Modeling - New parameter - Fields

 Add fields:

Create a slicer:

Create a card visual:

You will get the count of blank of that particulate column in the 1st table :

Best regards,

Yadong Fang

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

[ppriya]

Hi @v-yadongf-msft

Actually i am looking out for a solution where in i need not create multiple DAX.just on the basis of selection the tablename and fieldname changes and i get the output.

Any Suggestion

[v-yadongf-msft]

Hi @ppriya 

Did I solve your problem? If solved, please consider Accept it as the solution to help the other members find it more quickly.

Best regards,

Yadong Fang

[ppriya]

Kindly help with the issue .

[ppriya]

Correct Dax

Project_Measure_testing =

VAR vTablename = SELECTEDVALUE('Mapping table'[Table Name])

VAR vFieldname = "Filter('"&SELECTEDVALUE('Mapping table'[Table Name])&"',isblank('"&SELECTEDVALUE('Mapping table'[Table Name])&"'["&SELECTEDVALUE('Mapping table'[Field])&"]))"

Return vFieldname

--Calculate(count('Test Data'[ID]),vFieldname)