Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi
I have a column (called "CONCAT 4 Columns") as result of concatenating 4 other columns. Now, I need to get the number of rows having the value in each cell of "CONCAT 4 Columns" column, within the same column ("CONCAT 4 Columns").
I am using the below formula but I am getting "1" in return but as you can see in the screenshot I have 3. What am doing wrong?
Solved! Go to Solution.
Try,
CALCULATE(
COUNTA('*Raw: All ARA Users Tables Appended'[CONCAT 4 Columns]),
ALLEXCEPT('*Raw: All ARA Users Tables Appended'[CONCAT 4 Columns]),
)
Proud to be a Super User! | |
Many thanks, ALLEXCEPT resolved it. At the end it looks like this:
Try,
CALCULATE(
COUNTA('*Raw: All ARA Users Tables Appended'[CONCAT 4 Columns]),
ALLEXCEPT('*Raw: All ARA Users Tables Appended'[CONCAT 4 Columns]),
)
Proud to be a Super User! | |
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
93 | |
86 | |
76 | |
64 |
User | Count |
---|---|
138 | |
113 | |
107 | |
98 | |
92 |