Forum Discussion
Count with filter
I solved the problem by duplicating the "journey" column, then grouping it and finally adding a new calculated column in the original table using a Lookupvalue.
Hi User2 ,
If your table can present this one-to-one correspondence, then it is easy to do the calculations you want.
just create a measure to calculate,like this
value = SUM('Table'[number of Journey ])-SUM('Table'[number of back])Since the calculation is for the same row, it may be can't meet your needs when there is no correspondence between journey and journey back.
Best regards,
Community Support Team Selina zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi Anonymous ,
the problem is not how I calculate my value, the problem is how I can extract the number of journeys back out of the column "no. of journeys". All I receive is the same values for both columns.
Example:
I only get the values if column "journey" and "journey back" are identical, e.g. "F - F" and "F - F" but if it is "F- H" to "H- F" I cannot extract the value.
How did you count the number of journeys back? I don't get how I can count them without receiving the exact same values as for the column "journey".
Thanks for your help.
I solved the problem by duplicating the "journey" column, then grouping it and finally adding a new calculated column in the original table using a Lookupvalue.