Forum Discussion

jak8282's avatar
jak8282
Helper III
3 years ago
Solved

Using the logic for calculated column in ameasure

Hi,    I have the following code     Count = IF ( CONTAINSSTRING ( LOWER ( 'FINLIVE - Contact Details (Email & Phone)'[First Name] ), "dummy" ) || CONTAINSSTRING ( LOWER ( 'FINLIVE - Co...
Need Help
  • poweringthru's avatar
    poweringthru
    3 years ago

    You could have it as a calculated column on the table (since I'm only seeing reference to that one table 'FINLIVE - Contact Details (Email & Phone)', and then have your measures be:

    Total Test Records =
CALCULATE(
    COUNTROWS('FINLIVE - Contact Details (Email & Phone)'),
    'FINLIVE - Contact Details (Email & Phone)'[Count] = "Test Records"
)

    And:

    Total Clients =
CALCULATE(
    COUNTROWS('FINLIVE - Contact Details (Email & Phone)'),
    'FINLIVE - Contact Details (Email & Phone)'[Count] = "Clients"
)

     

poweringthru's avatar
poweringthru
Helper I
3 years ago

You could have it as a calculated column on the table (since I'm only seeing reference to that one table 'FINLIVE - Contact Details (Email & Phone)', and then have your measures be:

Total Test Records =
CALCULATE(
    COUNTROWS('FINLIVE - Contact Details (Email & Phone)'),
    'FINLIVE - Contact Details (Email & Phone)'[Count] = "Test Records"
)

And:

Total Clients =
CALCULATE(
    COUNTROWS('FINLIVE - Contact Details (Email & Phone)'),
    'FINLIVE - Contact Details (Email & Phone)'[Count] = "Clients"
)