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 everyone,
I need to create a visualization with a table that shows the substraction between 2 fields, both are coming from different tables of my model and the link between them is a "key" field.
Currently, the substraction is calculated in a third auxiliar table using the "key" field I mentioned before, and then just adding the result to the visualization.
I am wondering if there is a more smart way to do the same and I have worked in creating a MEASURE that could make the calculation in the context of the row, unfortunatly what I always get is the difference between totals.
To put it more graphical, I want YELLOW-RED in my last column:
If you need some extra info do not hesitate to ask me.
Thanks a lot in advandce for your help.
Regards!
Solved! Go to Solution.
First Try:
Use Calculate:
DifBetween2Columns=Calculate(Sum('Table1'[Horas de JIra])) - Calculate('Sum'(Table2[horas de EAC]))
First Try:
Use Calculate:
DifBetween2Columns=Calculate(Sum('Table1'[Horas de JIra])) - Calculate('Sum'(Table2[horas de EAC]))
Thank you very much for your fast and RIGHT answer!
I was obssesed trying to use CALCULATE with a filter argument but it is not necessary...
Jut to give something extra, DifBetween2Columns=Calculate(Sum('Table1'[Horas de JIra])- 'Sum'(Table2[horas de EAC])) seems to work same way and it avoids a CALCULATE formula...
Thanks again!
Kind regards
Making this calculation through a MEASURE is far more smart under my point of view but I have lost the possibility of creating a slicer or a visual filter from this field, I mean, I cannot use the MEASURE "DifBetween2Columns" as a filter.
Do you know how could I use this MEASURE as a filter?
Anyone replies to will be more than welcome as well.
Thanks again
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 |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |