Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hi,
I've done some quick measures to filter values, but when I check the Measure against the filter it only return the total sum, not per filter or what to say. Is it possible to fix this?
This is the DAX:
I want it to return the value like this (But without 85XX):
Have a nice friday all!
Solved! Go to Solution.
Hi,
Please try something like below if it suits your requirement.
Kost.belopp (aktuellt) for 18, 6, or 1 =
CALCULATE (
SUM ( 'Artikeltransaktion (2)'[Kost.belopp (aktuellt)] ),
FILTER (
'Artikeltransaktion (2)',
'Artikeltransaktion (2)'[Lagerställekod] IN { "18", "6", "1" }
)
)
Awesome! Thanks 🙂
Hi,
Please try something like below if it suits your requirement.
Kost.belopp (aktuellt) for 18, 6, or 1 =
CALCULATE (
SUM ( 'Artikeltransaktion (2)'[Kost.belopp (aktuellt)] ),
FILTER (
'Artikeltransaktion (2)',
'Artikeltransaktion (2)'[Lagerställekod] IN { "18", "6", "1" }
)
)
User | Count |
---|---|
13 | |
10 | |
8 | |
7 | |
5 |
User | Count |
---|---|
24 | |
16 | |
15 | |
10 | |
7 |