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
How turn off the Total on Column "Vendor Rate Description"?
This row is generated using a DAX Switch Measure and it is a Text based Column?
Solved! Go to Solution.
add additional if in your filter
if( isfiltered(Table[Account]) , <Your formula> , blank())
or you can also try isinscope
https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
@Sean-OReilly - You can turn off Totals in the Format pane. However, if you want it just for that measure,
Measure =
VAR __Calc = <some calc>
RETURN
IF(HASONEVALUE('Table'[AccountID]),__Calc,BLANK())
You can also get there doing a similar thing with COUNTROWS('Table') and comparing to COUNTROWS(ALL('Table')) if they are the same, then you are in a total row.
add additional if in your filter
if( isfiltered(Table[Account]) , <Your formula> , blank())
or you can also try isinscope
https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
Thanks man - it worked
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 |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |