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 everyone, I have the following slicer and table:
Given that my user could alter this table with the slicer, I'm trying to write a measure to calculate the number of rows contained in the table visual, for the example above, I'd be looking for 21.
Can anyone help?
Solved! Go to Solution.
Found the solution, COUNT should be DISTINCTCOUNT as there are multiple values for some days.
Thanks all
@Anonymous , countrows(Table)
or
count(Table[Day])
if days from different table
calculate(count(Day[Day]), not(isblank(Table[login time])))
Hi @amitchandak
As you can see, I got a result of 731 instead of 21
The DAX i entered was this:
I can't fathom why I can't just simply count the rows of the visuals.
Found the solution, COUNT should be DISTINCTCOUNT as there are multiple values for some days.
Thanks all
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |