Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi everyone,
I am really new using PowerBi and I am trying to find the way to create a measure using DAX code to receive the result of subtracting two total num values from same column using a filter from other column in the same table.
The example would be as follows:
- Filter column name: "Reference" with values '1' or '2'
- Total values in column name: "2024"
So imagine, the total value of 2024 using filter '1' is €5m and using '2' is €3m, so the result should be €2m.
Thank so much in advance!
Best regards,
Javier
Solved! Go to Solution.
1 | 5 |
2 | 3 |
1 | 5 |
2 | 3 |
It worked! Thank you so much. 🙂
Is there is a way so I can use a condittional formatting so the result shows an green icon for the positives and a red one for the negatives?
Something like this:
Thanks again!
You're welcome.
Please test out all scenarios.
Please create these two measures
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
70 | |
36 | |
21 | |
18 | |
15 |
User | Count |
---|---|
126 | |
30 | |
28 | |
24 | |
22 |