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 struggle with a problem of total value calculations. I want to create a matrix with a few columns. The situation is depicted on the below image. Basicly there are two measures (Measure1 and Measure2). Measure3 is calculated using the expression if(measure1 <> 0, measure2, 0). The final measure consist of a part of Measure2 and Measure3 (green and yellow cells). So far I have used HASONEVALUE but when the number of columns is changing it doen't make sense. I have been using SELECTEDVALUE but it also requires static number of columns in the table (SELECTEDVALUE-link). The goal is to calculate the last column FinalMeasure.
Gladly I will hear any suggestions from you on how to cope with this problem.
Hi @Anonymous,
Due to I could not figure out your logic of measure 1 and measure 2, I could not test for your data. Could you please offer a sample file to have a test if possible?
Regards,
Daniel He
Hi @v-danhe-msft,
finally I have resigned from this logic and implemented without it. I still don't know solution but it's irrelevant right now.
Kind regards,
Nicr
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |