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.
I have a table where I have to show Blank rows records in Header with Count and also all rows should be with Text Count as below.
TableApple
Column1 Column2
Apple Blank (No Value)
Apple American
Apple Indonesian
Apple Argentina
Apple Blank (No Value)
Apple American
Apple Argentina
Apple American
Apple Blank (No Value)
Apple Indian
Apple Blank (No Value)
Apple American
Apple Indian
Apple Argentina
Apple Blank (No Value)
--------------------------------------------
Result Should be as below :
Apple(5)-->Header of Table Header in Visual in Report Pane
American(4) -> row
Indonesian(1) -> row
Argentina(3) -> row
Indian(2) -> row
Solved! Go to Solution.
You may try the Matrix visual and use measure below.
Measure = IF ( ISINSCOPE ( TableApple[Column2] ), COUNT ( TableApple[Column2] ), COUNTROWS ( FILTER ( TableApple, ISBLANK ( TableApple[Column2] ) ) ) )
You may try the Matrix visual and use measure below.
Measure = IF ( ISINSCOPE ( TableApple[Column2] ), COUNT ( TableApple[Column2] ), COUNTROWS ( FILTER ( TableApple, ISBLANK ( TableApple[Column2] ) ) ) )
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |