Forum Discussion
Create a Measure based on string value
Kevykev Create a calculated column:
HasFTA := IF (Find("FTA",[Court Hearing Result],1,-1) = -1, 0, 1)
Create a new measure as FTACount = SUM([HasFTA]) in the same table where you created a new column "HasFTA"
Then a TotalRecords = CALCULATE(COUNTROWS(TABLE),ALL)
Percentages would be FTA% = [FTACount]/[TotalRecords]
Kevykev ,
YOu can create a measure based on string condition using FILTER DAX. Please follow the below DAX meausre to get your output:
Measure = CALCULATE(COUNT('Table'[Court Hearing Result]),FILTER(ALL('Table'),'Table'[Court Hearing Result]="FTA"),DATESBETWEEN('Table'[DateColumn],FIRSTDATE('Table'[DateColumn]),LASTDATE('Table'[DateColumn])))Don't forget to give thumbs up 👍 and accept this as a solution if it helped you.Thank you very much. This helps me greatly be getting an example that I can now see applied to my data model and business use case!
Thank you very much. This helps me greatly be getting an example that I can now see applied to my data model and business use case!
Kevykev ,
YOu can create a measure based on string condition using FILTER DAX. Please follow the below DAX meausre to get your output:
Thank you very much. This helps me greatly be getting an example that I can now see applied to my data model and business use case!