Sum of value - fixed sum of value

[Anonymous]

i have an account slicer on my dashboard,

account a

account b

account c

i have 2 tables each contain minutes column , lets call the first table acconytable and second one totaltable,

the slicer with account names is from accounttable, i want to create a difference of minutes. the totaltable minutes should be constant, but when i select an account  the totaltable minutes gets filtered too, i only want the minutes of account table to get filtered while totaltable stays constant, 

example sum of totaltable minute = 1.3 million

sum of all accounts mnutes of accounttable = 1 million

so difference is 0.3 which is working

but when i select an account example acount a, minutes = 0.4 million

the totaltable minute shows me the value of this account too which is 0.8 million

so instead of doing (1.3-0.4) it gives me (0.8-0.4)

any ideas how to make it work

[Anonymous]

Hi @Anonymous,

I'd like to suggest you add all function on your formula that used to calculate total to ignore filter effects, then you can get the difference between not filter records and current records:

Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT - SQLBI

If you are confused about the coding formula, share some more detail about your data structure to help us clarify your scnaiaro and test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[amitchandak]

@Anonymous , Based on what got

calculate(sum(totaltable[minutes]), allexcept(Account, Account[Name])) - Sum(acconytable[Minutes])

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Anonymous]

it didnt work ill post a sample give me a moment