Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
116 | |
102 | |
78 | |
76 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |