CODEWITHSUNDEEP
powerbimeasure
SQL_M
SQL_M

Reputation: 2475

Create measure based on several filter conditions PowerBI

I want to create a PowerBI measure, to perform some filter tasks.

Basically, I want to create a measure that returns 1 if ColumnA = empty OR column B is empty OR columns C = empty. I'm just getting started with measures and I am getting stuck.

My code attempt:

M_DataIssues = FILTER(
                      ALL(Table[ColA] ; Table[ColB] ; Table[ColC])
                          Table[ColA] = "" || Table[ColB]= "" || Table[ColC] = "")

Any help would be appreciated.

PS. due to my user permissions, I can only create measures. I do not have rights to do other modelling tasks or create columns e.g.

Thanks!!

KR ~M.

Upvotes: 0

Views: 143

Answers (1)

AnkUser
AnkUser

Reputation: 5531

enter image description here

will this measure work for you? if yes here is the formula

Measure = CALCULATE(DISTINCTCOUNT('Table'[ColumA]) || DISTINCTCOUNT('Table'[ColumB]) || DISTINCTCOUNT('Table'[ColumnC]);FILTER('Table';'Table'[ColumA]="" || 'Table'[ColumB]="" || 'Table'[ColumnC]=""))

Upvotes: 1

Related Questions