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,
In the following table, the values in the last column are calculated values (based on the two columns to the left, that are also calculated measures). I now want to obtain the sum of them by date, e.g.: 2.62+0.37+4.22 for 2017-01; 2.05+0.44+3.50 for 2017-02, etc.
Eventually I want the sum totals per date, without having to display the breakdown by category (VAR_CATEOGRY column) in the table.
I have no idea how to proceed.
Is there a way to share the PBIX file? Or should I share the data format & DAX formulas used for all the measures?
you could share your pbix-file to third-party cloud like https://uploadfiles.io/ and share thelink here
for your task maybe it would be enough to use ALLEXCEPT() statement like
Measure =
CALCULATE(SUM([Stability Index Factor), ALLEXCEPT('Table', 'Table'[DEV REC Capture month]))
do not hesitate to give a kudo to useful posts and mark solutions as solution
Hi,
I've uploaded another file: http://ufile.io/sfw9aa90
What I've tried to do in this newly uploaded file is to create a table using DAX, replicating what I've done in the individual measures. As a result I get exactly what I want (see below), but with one major problem: it remains static, i.e.: it is unaffected by selections from the slicers. So, if there is a way to get the DAX-created table to be affected by selections on the slicers, then I have my solution ...
Thanks.
I have uploaded the PBIX-file to: https://ufile.io/ztr3elwa
The option SUM([Stability Index Faxtor]) does not work, presumably because [Stability Index Faxtor] is a calculated field.
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 |
---|---|
112 | |
97 | |
84 | |
67 | |
61 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |