Create measure based on several filter conditions PowerBI

Question

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.

AnkUser AnkUser · Accepted Answer · 2020-02-19T14:56:10

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]=""))

Create measure based on several filter conditions PowerBI

1 Answers