Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
Unfortunately, so far I have not found the right solution or idea, or I have forgotten it.
My Dax is this:
Lager_Wert =
VAR Bezeichnung =
SELECTEDVALUE ( '03 ExportData_EvaluateChannelPrice'[Bezeichnung] )
VAR Produktfam =
SELECTEDVALUE ( '03 ExportData_EvaluateChannelPrice'[Produktfam] )
VAR Lager =
SELECTEDVALUE ( '08 Lagerwert'[Lager] )
RETURN
SWITCH (
TRUE (),
ISINSCOPE ( '03 ExportData_EvaluateChannelPrice'[Bezeichnung] ),
CALCULATE (
SUM ( '08 Lagerwert'[Anzahl] ),
FILTER (
ALLSELECTED ( '03 ExportData_EvaluateChannelPrice' ),
Bezeichnung = '03 ExportData_EvaluateChannelPrice'[Bezeichnung]
)
)
* CALCULATE (
SUM ( '03 ExportData_EvaluateChannelPrice'[Bewertungspreis] ),
FILTER (
ALLSELECTED ( '03 ExportData_EvaluateChannelPrice' ),
Bezeichnung = '03 ExportData_EvaluateChannelPrice'[Bezeichnung]
)
),
ISINSCOPE ( '03 ExportData_EvaluateChannelPrice'[Produktfam] ),
CALCULATE (
SUM ( '08 Lagerwert'[Anzahl] ),
FILTER (
ALLSELECTED ( '03 ExportData_EvaluateChannelPrice' ),
Produktfam = '03 ExportData_EvaluateChannelPrice'[Produktfam]
)
)
* CALCULATE (
SUM ( '03 ExportData_EvaluateChannelPrice'[Bewertungspreis] ),
FILTER (
ALLSELECTED ( '03 ExportData_EvaluateChannelPrice' ),
Produktfam = '03 ExportData_EvaluateChannelPrice'[Produktfam]
)
),
ISINSCOPE ( '08 Lagerwert'[Lager] ),
CALCULATE (
SUM ( '08 Lagerwert'[Anzahl] ),
FILTER ( ALLSELECTED ( '08 Lagerwert' ), Lager = '08 Lagerwert'[Lager] )
)
)
My Problem is, for is ISINSCOPE ( '03 ExportData_EvaluateChannelPrice'[Produktfam] ) and ISINSCOPE ( '08 Lagerwert'[Lager] ).
I dont want to multiply the Values I want the Grandtotals coming from ISINSCOPE ( '03 ExportData_EvaluateChannelPrice'[Bezeichnung] ) for Produktfam and Grand Total Coming from Produktfam for Lager.
Unfortunately I can't upload a picture of the current result.
So here is a table with the current result of my meassure and the result I want.
Hierarchie | Anzahl | Bewertungspreis | Lagerwert (My Meassure) | What I want |
Lager 1 | 180 | 26 | 4680 | 650 |
Produktfarm 1 | 100 | 1 | 100 | 100 |
Bezeichnung 1 | 100 | 1 | 100 | 100 |
Produktfarm 2 | 80 | 25 | 2000 | 550 |
Bezeichnung 1 | 70 | 5 | 350 | 350 |
Bezeichnung 2 | 0 | 10 | 0 | 0 |
Bezeichnung 3 | 20 | 10 | 200 | 200 |
Many thanks in advance!
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
114 | |
100 | |
97 | |
72 | |
68 |