Forum Discussion

slipstream's avatar
slipstream
New Member
7 years ago
Solved

Measure formula help

Hi   Im trying to create a measure to count the total unique records where template starts with AB-   unique template date       abc AB-123 Jan-19 abcd AB-124 Feb-19 abcde ...
Need Help
  • vanessafvg's avatar
    vanessafvg
    7 years ago

    slipstream 

     

    hi thats is quite strange, ive added your data to a model and run your calculation and i get 5, can you share your pbix?

PattemManohar's avatar
PattemManohar
Community Champion
7 years ago

slipstream  Your Measure logic is returning 5 as well, not sure why it is 3 at your end ?

 

Please try this as a New Measure... 

 

Test238 = COUNTROWS(FILTER(Test238Measure,LEFT(Test238Measure[Template],3)="AB-"))

  • slipstream's avatar
    slipstream
    New Member
    7 years ago

    apologies all, seems it was working, just my ability to type wasnt ! :)

     

    thank you all for your help

    cheers