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,
I need to filter sales as following:
And then calculate these sales together.
I also need to report sales the other way around, that means all sales of reporting group 1: 1003, except for those sales, that were included in the first report above.
Can somebody help me figure out how to do this?
Thanx in advance!
Hi @sw123
It's gets difficult to answer without seeing the data. Can you share your data or pbix without pii.
!) Still, I can think of 2 approaches here, either create a custom column as per your needs and grouping that are required and then use them as filters in your dax.
2) The filters that you have shared, if those are required then you can include them in your dax and in the 2nd formula you can calculate total sales and subtract your 1st measure from total sales.
Thanks,
Ankit
www.linkedin.com/in/ankit-kukreja1904
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |