Forum Discussion

selkrom's avatar
selkrom
New Member
3 years ago

Strugling with Filters



Thats my Data Struktur And my Report

BelegeEk = there are my supplier invoices
Belege = there are my invoices i sell to my customer

BelgpostionenEk there are all Invoice positions from buying
Belgpostionen there are all Invoice positions from selling

In 1 i want al my Suppliers and the amount i spend to them 

in 2 i want to see wich articel i buyed from them and the amout i spent based on the articels

In 3 i want to se based on the artikel selection of 2 how much money i made with the articels from that supplier

1 and 2 work but i have problems with 3 when i put my measure there and i select a supplier the tabel is empty:

mesure = 

CALCULATE(SUM(Belegpositionen[Nettobetrag]), ALLEXCEPT(Artikel,Artikel[Artikelnummer])

can someone help me ?

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi selkrom ,

    Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

    How to Get Your Question Answered Quickly  

    Regards,

    Xiaoxin Sheng