Forum Discussion
filter and search
I seem to be getting closer to my solution, however, the measureC column shows all values the same which is the sum of the MeasureB with ColumnA starting with 1 or 5
Question, all data is from one table
Not sure why all rows in MeasureC are repeated with the sum of MeasureB
This is my DAX
CALCULATE(
[MeasureB]
, not ISBLANK('TableName'[ColumnA]) && SEARCH(".", 'TableName'[ColumnA],,0) = 0
&& LEFT('TableName'[ColumnA], 1) = "1"
||LEFT('TableName'[ColumnA], 1)= "5"
|| LEFT('TableName'[ColumnA], 1)= "6"
|| LEFT('TableName'[ColumnA], 1) = "7"
|| LEFT('TableName'[ColumnA], 1) = "8"
|| LEFT('TableName'[ColumnA], 1) = "9"
)
Anonymous not going into your measure, add following
CALCULATE(
[MeasureB]
,
KEEPFILTERS(
not ISBLANK('TableName'[ColumnA]) && SEARCH(".", 'TableName'[ColumnA],,0) = 0
&& LEFT('TableName'[ColumnA], 1) = "1"
||LEFT('TableName'[ColumnA], 1)= "5"
|| LEFT('TableName'[ColumnA], 1)= "6"
|| LEFT('TableName'[ColumnA], 1) = "7"
|| LEFT('TableName'[ColumnA], 1) = "8"
|| LEFT('TableName'[ColumnA], 1) = "9"
)
)using your DAX but this time nothing is shown into the column
Anonymous i would recommend to share pbix wiht sample data to look into it. information you provided is hard to work with until someone else can assist you wiht this.
Hi Anonymous ,
Have you solved your problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please feel free to ask.
Best Regards,
Cherry
