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 everyone!
I am working on a BI that has SKUs, also a column called "Status Salas" that has the values : Ok, Critical, Medium and Low which is with respect to each SKU and another column that is Sell 2019 and 2020 of each product.
to this you create a measure that is THE variation so : variation so s SUM(2020)- SUM(2019) / SUM(2019)
WHEN YOU LOOK AT THE TABLE IT LOOKS LIKE THIS :
where when I check the so variation of each status you can see that it correctly gives its percentage. But when I want growth with a filter that selects the 3 status gives me another value. In the total table you can see that the sum of 2019 and 2020 is not the same if we make it manual, so growth is taking bad inputs.
Should I use the calculate function? Please help
Hi @CLCastroEn ,
Please share us a dummy .pbix file with the same issue and the same data structure of your real data. Please remove sensitive information.
Best Regards,
Icey
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 |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |