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.
Hello Guys,
I am using an excel file as my data source. I am working with my table product at the moment specifically with the fields Sales Revenue and States. I want to create a new measure on that table that will calculate the total revenue but only for the state on New york and with the use of variables. So with the declaration of my measure, i have created two variables one that hepls me filter the state of New York and another one that sums the field Sales revenue. Then i returned the result of the use of the CALCULATE FUNCTION.
As you can see on the pictures the variable that sums my revenue but the one with the filter does not work. I am supposed to have 7.5 millions euros for New York's revenue. It works when i create another measure just to calculate the sum of the revenue but i rather not proceed like that for performance measures.
Does anyone please know where i went wrong?
Regards,
Tatiana
this is my DAX expression:
Solved! Go to Solution.
I think the issue is that second VAR evaluates the SUM before the filter context from the first VAR is applied, so it returns a scalar value
CALCULATE(SUM(Produits[Sales_revenue]),NewYorkSales)
should work fine
I think the issue is that second VAR evaluates the SUM before the filter context from the first VAR is applied, so it returns a scalar value
CALCULATE(SUM(Produits[Sales_revenue]),NewYorkSales)
should work fine
Covering 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 |
---|---|
114 | |
100 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |