Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
i have a table visual(see below), where i have 2 coloumn Gter and Margin, see below
what i want to do is show the total of GTER coloumn only, not margin total
how do i do that?
Solved! Go to Solution.
please ignore, i figured it out, i just had to push the coloumn to "Dont summarize" and it resolved the issue
You will need to add a condition to your margin measure to prevent a result in the "total" row. You didn't show the column(s) in your table but you need something like this.
Account Margin % YTD = IF(HASONEVALUE(Table[Column]), [Account Margin % YTD])
This will return blank in the total row. Replace Table[Column] with one of the columns in your table. Also, you can reference your existing margin measure as shown, or just wrap your current expression with the IF(HASONEVALUE ....).
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Note: Account Margin % YTD is a coloumn and not measure.
so the below formula you have provided doesn't works, i tried and its showing me everything blank
please ignore, i figured it out, i just had to push the coloumn to "Dont summarize" and it resolved the issue
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |