Hi. I'm learning by doing PBI through an opportunity at work and I'm having a problem to insert measures into Axis field. It seems that the only accepted is if I create a calculated column. I'm not sure why but the measures are giving me the correct results and the calculated columns aren't. Can someone please review the DAX below and help me? The goal is to count blank rows from two or more columns of customers missing certain contact details like address, cellphone, or email, and distribute each of them by categories using bars. Thanks!
Measure:
Total Mobile Missing = IF(ISBLANK(COUNTROWS(FILTER(TableName,ISBLANK(TableName[ColumnName1])))), 0, COUNTROWS(FILTER(TableName,ISBLANK(TableName[ColumnName1]))))
Calculated column Option 1:
CombinedCategory = IF( ISBLANK('YourTable'[ColumnName1]) && ISBLANK('YourTable'[ColumnName2]), "Missing Email & Mobile", IF( ISBLANK('YourTable'[ColumnName1]), "Missing Mobile Number", IF( ISBLANK('YourTable'[ColumnName2]), "Missing Email Address", IF( ISBLANK('YourTable'[ColumnName3]), "Missing Home Phone", "No Missing" ) ) ) )
Calculated Column Option 2:
Combined Category = SWITCH( TRUE(), ISBLANK([ColumnName1]) && ISBLANK([ColumnName2]), "Missing Mobile & Email ", ISBLANK([ColumnName1]), "Missing Mobile Number", ISBLANK([ColumnName2]), "Missing Email Address", ISBLANK([ColumnName3]), "Missing Home Phone", "No Missing" )
