Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have one table with following columns:
I want to calculate following measures:
I want to show the Final value in the table something like:
I want to know how can I apply where condtion with the same table's column and get the correct count.
Solved! Go to Solution.
hi, @Dhruvin
You could use this formula as below:
document Count by Transaction Originator = CALCULATE(COUNTA('Table'[document Number]),ALL('Table'[User ID]),'Table'[Transaction Originator] in VALUES('Table'[User ID]))+0
Best Regards,
Lin
HI, @Dhruvin
You could try these formulae as below:
Count of Document Number by User ID = CALCULATE(COUNTA('Table'[document Number])) document Count by Transaction Originator = CALCULATE(COUNTA('Table'[document Number]),FILTER('Table','Table'[User ID]='Table'[Transaction Originator]))+0 Percentage = [document Count by Transaction Originator]/[Count of Document Number by User ID]
Result:
If not your case, Please share some data sample and expected output for us. Do mask sensitive data before uploading.
Best Regards,
Lin
Thnaks for your effort.
I really appriciate it.
I am looking for different o/p.
As per your output User ID and Document Count by User Id is correct. But for Document Count by Transaction Originator I'm looking for the output something like below:
For User ID - A001 - document Count by Transaction Originator should be = 3 instead of 2. I need all the count of Document by Transaction Originator but only want to represent wrt UserID.
Same, UserID - A002 document Count by Transaction Originator should be = 5 instead of 3.
I know it's bit confusing.! Hope you understand.
hi, @Dhruvin
You could use this formula as below:
document Count by Transaction Originator = CALCULATE(COUNTA('Table'[document Number]),ALL('Table'[User ID]),'Table'[Transaction Originator] in VALUES('Table'[User ID]))+0
Best Regards,
Lin
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |