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.
Below is the table and count of Reason code is the result I am trying to get in power BI. In first coloumn same Document number is there and against each document either there is reason code present or not present . I want to count and reflect the number of reason codes against each row .
For eg. 123 document has total of 3 reason codes. so 3 count will reflect against each 123 row.
my excel formula to claculate count of reason code is :
Docs | Reason Code | Reason Code (Y/N) | Count of Reason code |
123 | x | 1 | 3 |
123 | 0 | 0 | 3 |
123 | x | 1 | 3 |
123 | x | 1 | 3 |
231 | 0 | 0 | 1 |
231 | x | 1 | 1 |
231 | 0 | 0 | 1 |
231 | 0 | 0 | 1 |
I tried below DAX formula but it is giving me the total of all reason codes. But I want sum of Reason code come against each document =
Solved! Go to Solution.
Hi @vineet2504
Try following
= CALCULATE ( SUM ( Sheet1[reasoncode] ), ALLEXCEPT ( sheet1, sheet1[Docs] ) )
You could try this as well:
[Count of Reason Codes] = var __oneDocVisibleAndDirectltyFiltered = HASONEFILTER( T[Docs] ) var __reasonCodeCount = CALCULATE( SUM ( T[Reason Code (T/N)] ), VALUES( T[Docs] ), ALL( T ) ) return if( __oneDocVisibleAndDirectlyFiltered, __reasonCodeCount )
Best
Darek
Hi @vineet2504
Try following
= CALCULATE ( SUM ( Sheet1[reasoncode] ), ALLEXCEPT ( sheet1, sheet1[Docs] ) )
This is working. Thanks dude.
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 |
---|---|
43 | |
21 | |
20 | |
15 | |
13 |
User | Count |
---|---|
45 | |
41 | |
39 | |
19 | |
19 |