Forum Discussion

rapingali's avatar
rapingali
Frequent Visitor
4 years ago
Solved

Using SELECTEDVALUE function when more than one value is selected in Filter

Hi All,   I Have a requirement to display total sales, total comission amount for a selected year. We have two different dates Order Date, Commision Paid Date and two measures  SalesAmount, Comissi...
Need Help
  • parry2k's avatar
    parry2k
    4 years ago

    Well, what is the point of having a model which cannot do a simple thing? There is always an argument, to improve a model to simplify DAX or write complex DAX to achieve the results, and seems you are falling into 2nd category, which is usually not a good idea because it can have a performance impact and a solution which cannot be scaled over time.

     

    Having said that, you can try this DAX function.

     

    Sales_Amount =

CALCULATE(
Sum('Sales_Table'[Sales_Amount]),
REMOVEFILTERS('Commision_Table'),
TREATAS ( 
   VALUES('Commision_Table'[Commision Year]),
   'Order_Table'[Order Year]
)
)

     

    ✨ Follow us on LinkedIn and  to our YouTube channel

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

     

    ⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

parry2k's avatar
parry2k
Super User
4 years ago

rapingali you should create a date dimension in the table and then use that to link with both the tables (commission and sales) and in visual use date-related columns from the date dimension. This will follow the best practices.

 

You can follow my video here on time intelligence and create basic date table: Learn basics of Time Intelligence DAX functions - Part 1 - YouTube

 

 

, {"Start Date", type date}