Forum Discussion
Helper IIIHow to remove 'Total' for a column/measure in Table?
Hi Team,
I am not able get any resource to remove a 'Total' from a selected column.
Any suggestion to implement it.
As you can see from screenshot. i want to show Total only for 'Fuel Rate'.
and 'lastEngineHoursDate' is a measue which return Max(date).
Does't make sense to have Total on 'lastEngineHoursDate'.
Here 'datestamp' is column and 'lastEngineHoursDate' is measure.
Both Formate to 'Date'.
You can modify your lastEngineHoursDate measure to show a different value when it is on a row (plotted against an Asset) vs the total (against multiple assets) e.g.
lastEngineHoursDate =
VAR OneAsset =
HASONEVALUE ( 'Asset Table'[Asset Name] )
RETURN
IF ( OneAsset, MAX ( date ), BLANK () )
2 Replies
- rsaprano
Most Valuable Professional
You can modify your lastEngineHoursDate measure to show a different value when it is on a row (plotted against an Asset) vs the total (against multiple assets) e.g.
lastEngineHoursDate =
VAR OneAsset =
HASONEVALUE ( 'Asset Table'[Asset Name] )
RETURN
IF ( OneAsset, MAX ( date ), BLANK () ) 
v-chuncz-msftCommunity Support