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.
Good day,
we have a list of data as below:
We would like to filter the y status and calculate the total Y and n and display in the dashboard
Code | Status |
507af44e55e76305da17f0349c47254e | n |
a8f5985ba2ac6f33787015b7ca1e44e4 | y |
7b1966b4648969cb817952344e1e58b7 | y |
203e99e59f1cbc6c9e777658436af305 | n |
0af6270178d703c78089efa7f32b96a3 | y |
59129e6d4d5dbb6bd9f4b29c22c40016 | n |
7a7f2bcc8fdbfa6c2bd28c49a11601f7 | n |
Result required would be:
Status y = 3
Status n = 4
Solved! Go to Solution.
If all codes are unique: [measure] = countrows( T ). If not, then [measure] = distinctcount( T[Code] ).
Then just slice by the relevant atttributes.
Hi @kerbaumalas
You could create a measure
Count by Status = COUNT('Table'[Code])
or
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
Hi @kerbaumalas
You could create a measure
Count by Status = COUNT('Table'[Code])
or
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
If all codes are unique: [measure] = countrows( T ). If not, then [measure] = distinctcount( T[Code] ).
Then just slice by the relevant atttributes.
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |