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
Hi All, just asking for help on how can I create a Total but instead of sum it should be difference of the two selected measure in the Field Parameters. See below and attached sample PBI file on how it looks like:
Here is the download link for the sample pbix file: https://www.dropbox.com/s/6qrb5seyty1d2l4/sample.pbix?dl=0
Thank you so much for the help!
Solved! Go to Solution.
Hi, not sure if this is possible, the top most what i could achieve is something like that
you just create a switch measure =
Hi @krixtsup3r
Please refer to attached sample file with the proposed solution.
Thank you @tamerj1!
Also, what if I selected more than 2 months in it? What it should do actually is add the 3 months for both parameters and then do the difference.
The output should be like this:
Awesome this works! Thank you!
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 |
---|---|
22 | |
21 | |
19 | |
13 | |
12 |
User | Count |
---|---|
41 | |
31 | |
23 | |
22 | |
22 |