How do I edit the DAX below so that the column doesn't return a total value?

[HamidBee]

I am working with the following DAX:

Petrol or Diesel = 
VAR A =
    ADDCOLUMNS (
        'Parking Data',
        "Petrol or Diesel",
            IF (
                [Petrol Price (£)] = SUM ( 'Data'[Amount] ),
                "Petrol",
                "Diesel"
            )
    )
RETURN
    MAXX ( A, [Petrol or Diesel] )

The issue with this DAX is that it gives me a total of either "Diesel" or "Petrol". Please see below:

How do I stop the total from showing (for this column only)?.

[parry2k]

@HamidBee can you share one drive/google drive, I don't like to use any other website. Sorry 

[HamidBee]

I was honestly about to get around to it. Opened the thread and I saw that someone provided a solution. Thanks anyway. 

[parry2k]

@HamidBee can you post the raw data and what you are trying to achieve? 

[HamidBee]

I can't share the exact file as it contains sensitive data but please find attached an example file I have created below:

https://www.mediafire.com/file/8j45jqb8uj41mzr/Example_File.pbix/file

You will see a visual of a matrix. The matrix has totals under each column. For the "Petrol or Diesel" column there is a total of "Diesel". What I'd like is for there to be no total to show for that column only. 

Thanks in advance.

[Ashish_Mathur · Accepted solution]

Hi,

Try this measure

Petrol or Diesel = if(hasonevalue('Table'[ID]),if([Total]=1,"Petrol","Diesel"),BLANK())

Hope this helps.

[HamidBee]

Thank you, this worked beautifully. I have never used the HASONEVALUE function. I had a read through the Microsoft documenation but I didn't fully understand it. In the code you have written is HASONEVALUE used to iterate through all of the IDs to determine if there is a unique value and if there is it returns blank?. 

Thanks

[Ashish_Mathur]

You are welcome.