Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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" )
@diddydidit , You have to do segmentation for that
three way
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k
Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ
Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: https://youtu.be/EyL7KMw877Q