Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I have a requirement where I need to show the sales that were generated in the last three days. To Solve this I created a calculated column based that will tell me when the order was created in the last 24 hours or 24-48 hours or 48-72 hours.
I used this calculated column as a slicer and applied it on the Total Sales Measure I created. Now I have a new requirement where I have sum the data based on the user selection so when user selects 24-48 It should sum up the data from both 24 and 24-48 instead of just showing the
Any help in this regard would be great.
Solved! Go to Solution.
Hi @rampsaladi,
Have you tried the solution provided by @MFelix above? Does it work in your scenario? If it works, could you accept it as solution to close this thread?
If you still have any question on this issue, feel free to post here.
Regards
Hi @rampsaladi,
Have you tried the solution provided by @MFelix above? Does it work in your scenario? If it works, could you accept it as solution to close this thread?
If you still have any question on this issue, feel free to post here.
Regards
Hi @rampsaladi,
You should try something like this to had to your model:
Total Sales = CALCULATE( SUM(Table[Values]);Table[Range] IN {"24"; "24-48" } )
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |