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.
HI Team
i do have this below table
Area | Case |
Sydney | Review |
Sydney | Accepted |
Melbourne | Dispute |
Melbourne | Dispute |
Melbourne | Review |
Perth | Accepted |
Perth | Review |
Sydney | Dispute |
Perth | Dispute |
Melbourne | Review |
i like this way in Power Bi
K | L | M | N | O | P | Q | R |
Row Labels | Accepted | % completed | Dispute | % completed | Review | % completed | Grand Total |
Melbourne | L3/R3 | 2 | N3/R3 | 2 | P3/R3 | 4 | |
Perth | 1 | L4/R4 | 1 | N4/R4 | 1 | P4/R4 | 3 |
Sydney | 1 | L5/R5 | 1 | N5/R5 | 1 | P5/R5 | 3 |
Grand Total | 2 | L6/R6 | 4 | 4 | 10 |
with countx function in Power Bi measure
can anyone guide me. Heaps thansk i
Solved! Go to Solution.
@Anonymous
Based on the above sample data, what exactly do you need to count? Please provide the expected result.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Anonymous
Create two measures: I attached the file below my signature.
Count = COUNTROWS(Table1)
Count % =
DIVIDE(
[Count],
CALCULATE(
[Count],
ALLSELECTED(Table1[Case] )
)
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Anonymous
You do not need a calculation. Insert a matrix visual onto the report canvas, add the AREA to Rows section and the CASE to Column selection then insert a CASE again to the Value section and set the aggregation to COUNT
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
i am counting in excel by pivot table like this
like this
@Anonymous
Create two measures: I attached the file below my signature.
Count = COUNTROWS(Table1)
Count % =
DIVIDE(
[Count],
CALCULATE(
[Count],
ALLSELECTED(Table1[Case] )
)
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Heaps thanks mate, all good. i got what i wanted. appriciate your help
@Anonymous
Based on the above sample data, what exactly do you need to count? Please provide the expected result.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
HI Fowmy, thanks for replying,
I am counting how many % complted every Area by case wise. like Sydney is having 4 rows then how many % for Review, Dispute....
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 |
---|---|
102 | |
53 | |
21 | |
12 | |
12 |