Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hello there,
i'm writing a Dax Measure in Order to do an conditional Calculating at the Item Ledger Entry of articles.
I have 3 amounts with article numbers to do a different calculation.
The Switch Case will proof the number and based on that the SUM of the Ledger Entry will be divided with 9, 11 or 15
Till now my Code is like this
Measure =
Solved! Go to Solution.
Hi @Power-CJ ,
Does the "IN" operator work in your case?
Here an example:
Let me know if this helps 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Proud to be a Super User!
Hello Tom,
thanks for the quick Response.
There Where you placed 'Table'[Order] I only can place Measure and no Columns of Table.
But when i set the function SELECTEDVALUE() in front of the column it will work.
thanks a lot
Hi @Power-CJ ,
Does the "IN" operator work in your case?
Here an example:
Let me know if this helps 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Proud to be a Super User!
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!