Single record select and show all history

[samdthompson]

I have a model thats working beutifully. I have been asked to add a new page to the report where users can select a single invoice  based on a variance from an average (all working fine) and see an entire 12 month history for that supplier. The aim is to show that if we have a big variance on a single record based on all the other supplier information are we going to be particularly concerned or not.

I have a working solution to give me a total value for the past 12 months:

Total Head (mob exceptions) =
CALCULATE([Total SU],
ALL(Data[Mob_ID]),ALL('Date'),
FILTER(ALL('Date'),'Date'[Rolling 12 month]="12mo"),
FILTER(Suppliers,Suppliers[Supplier ID]=LOOKUPVALUE(Data[supplier_id],Data[Mob_ID],FIRSTNONBLANK(Data[Mob_ID],1)))

)

The problem is somewhere in the product type but i cannot for the life of me find it.

Any help appreciated.

Cheers,

[CheenuSing]

Hi @samdthompson

Can you please share the pbix in one drive or google drive and share the link here.

Cheers

CheenuSing

[samdthompson · Accepted solution]

sorry, the file is too large to remove any commercially sensitive info from. i will see if i can jimmy up a stripped down version.