Hello all,
In table visualization I have a text column for the same column I want to show the count of rows in Total section. How Can i do that without adding a new value column?
@AlexisOlson @amitchandak @ValtteriN
Ex: Desired Output:
Column 1 Column 2
A123 Fan
B123 Bag
C123 Phone
--------------------------------
Total = 3
Solved! Go to Solution.
@dhanekula1996 you can write a measure like this
Measure = if(HASONEVALUE('Table'[Column 1]),CALCULATE(MAX('Table'[Column 2])),COUNTROWS('Table'))
Proud to be a Super User!
New Animated Dashboard: Sales Calendar
@dhanekula1996 you can write a measure like this
Measure = if(HASONEVALUE('Table'[Column 1]),CALCULATE(MAX('Table'[Column 2])),COUNTROWS('Table'))
Proud to be a Super User!
New Animated Dashboard: Sales Calendar
Thank you!!
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
User | Count |
---|---|
104 | |
58 | |
45 | |
29 | |
24 |
User | Count |
---|---|
133 | |
94 | |
75 | |
44 | |
41 |