Forum Discussion

User2's avatar
User2
Frequent Visitor
3 years ago
Solved

Count with filter

Hey guys,   I am new to Power BI and I need help with the following problem.   I have a column1 with journeys and in the second column I counted them using the aggregation count. In the third co...
Need Help
  • User2's avatar
    User2
    3 years ago

    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.

User2's avatar
User2
Frequent Visitor
3 years ago

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.

User2's avatar
User2
Frequent Visitor
3 years ago

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.