Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello community!
I am trying to create a measure that calculates the total product sales for a specfic month only for does products that has been sold the same period last year.
The second thing I did was to create a Comparable range flag as measure:
To demonstrate my problem I have used the ContosoRetailDW sample database with a simple star scheme consisting in the tables "FactSales", "DimDate" and "DimProduct"
Thanks in advanced for any help.
Solved! Go to Solution.
I re-wrote the solution to the following:
A measure is returning a scalar value. A filter expects a table. Rewrite your second measure to incorporate the same logic as you did in the first.
I adjusted the measure to create the CompRangeTable based on DimProduct instead of the fact table:
It should return 13,811,177 on each row which is the total:
Use a step by step approach with variables and use EVALUATEANDLOG to ensure each step is producing the desired result.
I re-wrote the solution to the following:
Thank you for you respons Ibendlin!
When you say the second measure, do you mean I should adjust this one ?
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
76 | |
74 | |
55 | |
45 |
User | Count |
---|---|
117 | |
106 | |
77 | |
66 | |
65 |