Have a measure only appear once instead of repeating on all rows

[JemmaD]

Hi there,

I have a fact table [Services] which holds difference services by account. I have a dim table [Fees] which holds the fee paid for services by account. There is only one fee per year, per account.
I have a measure which calculates the fee [Annual Fee Agreed], but when I add it to a matrix to show the fee per account along with the servies, naturally the Fee measure is repeating the same value against each service. I want it to only appear once. I have tried a HASONEVALUE argument but it's not working. 

Here is my table, can you help me with DAX syntax to have the Annual Fee perhaps displayed only in the total row?

[Ashish_Mathur]

Hi,

Does this measure work?

Measure = if(hasonefilter(Data[Service type]),blank(),[Annual fee agreed])

If this does not help, then share the download link of the PBI file.

[PijushRoy]

Hi @JemmaD 
Please use 
ISINSCOPE https://learn.microsoft.com/en-us/dax/isinscope-function-dax

Could you please share the DAX

Let me know if that works for you

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

[JemmaD]

@PijushRoy I wouldn't know where to start with that, I am hoping for help with syntax.

My Fee amount is 'Fees'[Amount Agreed]
The Schedule year is both in 'Fees'[Schedule_Year] and the date dim as 'Dates'[Schedule Year]

My [Anuual Fee Agreed] measure currently is:

Annual Fee Agreed = 
SUMX ( 
    SUMMARIZE ( 'Fees' , 'Fees'[ARCH_ACCOUNT] , 'Fees'[Amount Agreed] ),
    'Fees'[Amount Agreed]  )

But this doesn't summarise the Fee once per account.

[Daniel29195]

@JemmaD 

https://community.fabric.microsoft.com/t5/Desktop/Matrix-visual-Show-Count-of-event-when-aggregated/...