Forum Discussion
Adding a count column based on values from another column
Hi akkitek
Thanks for the reply from lbendlin .
If I understand correctly, you are trying to calculate how many Engagement Divisions there are per client.
What are your calculation criteria? Do you not double count the same division? I'm a little confused about the expected result you are giving, if I understand you correctly, then the expected result for A-00103 should be 2, not 3?
Since I found that the FACT_Fin_Data_by_Mo table contains the three columns used in the visualization chart, why do you have to use three tables instead of the FACT_Fin_Data_by_Mo table? Here's what I've done so far, I used the three columns from the FACT_Fin_Data_by_Mo table and then I created the following measure:
of divisions per client = CALCULATE(DISTINCTCOUNT(FACT_Fin_Data_by_Mo[Engagement Division]), ALLEXCEPT(FACT_Fin_Data_by_Mo, FACT_Fin_Data_by_Mo[Client Number]))Output:
You can also use a calculated column if you want, as shown here:
Please feel free to correct me if I have misunderstood you.
Best Regards,
Yulia XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
you can create a calculated column but only if the result cannot be influenced by users interacting with your report. In those cases you would need a measure.
In which way do you want to use that column further?
Thanks for your reply lbendlin ,
What I meant by using the column further was, after we count the number of divisions per client we need to use that column to flag how many clients have more than 2 divisions.
Depending on how you expect user interaction with your report to impact the results you can still choose to implement this either as a calculated column or a measure.