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.
Hello,
CALCULATE(MAX('Key Measures', 'Key Measures'[Group Avg life]) - MAX('Key Measures','Key Measures'[Group Stdev])) |
Group | Item | Average Group life | Standard Deviation |
Group 1 | Item 1 | 9 | 3 |
Group 1 | Item 5 | 9 | 3 |
Group 1 | Item 7 | 9 | 3 |
Group 1 | Item 8 | 9 | 3 |
Group 2 | Item 3 | 15 | 4 |
Group 2 | Item 6 | 15 | 4 |
Group 2 | Item 10 | 15 | 4 |
Group 3 | Item 2 | 11 | 2 |
Group 3 | Item 4 | 11 | 2 |
Group 3 | Item 9 | 11 | 2 |
Thank you for your time,
JE
Solved! Go to Solution.
Hi @Anonymous ,
I have no access to your dummy .pbix file. So I create one based on the dummy sample data you provided. And the [Group Lbound] measure reutrns value.
I find that the data type of [Group Avg Life] is "Text". Maybe this is the cause. Try to create your [Group Lbound] measure like so:
Group Lbound = CONVERT ( [Group Avg Life], DOUBLE ) - [Group Stdev]
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Is this problem solved?
Best Regards,
Icey
Hi @Anonymous ,
Please share me some sample data of both "Main Database" and "Book Table" or just a dummy .pbix file. Please ensure that the structure of the sample data is consistent with the real data. Please remove sensitive information and replace real data with dummy data.
It is suggested to upload your file to OneDrive for Business and then paste the link here.
Best Regards,
Icey
Hi Icey,
Here is the link to the excel dummy file I made - https://1drv.ms/x/s!AqlgOE-KAGt_zkvY2U9A7lAQt9HH?e=r2yVbK
Here is the link to the dummy pbix file I made - https://1drv.ms/u/s!AqlgOE-KAGt_zk3Id5OzD7wkO5B1
Sorry about taking so long to respond, it took me a bit of time to actually create these. The maddening part about this is that in the dummy file the two measures subtract! Everything is the same logic and exact code but it works in one and not the other. Obviously my dataset is much larger than this so I am trying to figure out what is going wrong. My thoughts are there is something in the dataset itself that is causing the display to break. So far the only ways I've been able to make the "Difference" measure to not display in the dummy is by having a years in service that is blank or negative. None of which exist in my database. If you have any other ideas on what may cause this measure to not work it would be greatly appreciated to be able to solve this.
Thanks again!
-JE
Hi @Anonymous ,
I have no access to your dummy .pbix file. So I create one based on the dummy sample data you provided. And the [Group Lbound] measure reutrns value.
I find that the data type of [Group Avg Life] is "Text". Maybe this is the cause. Try to create your [Group Lbound] measure like so:
Group Lbound = CONVERT ( [Group Avg Life], DOUBLE ) - [Group Stdev]
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
116 | |
104 | |
77 | |
71 | |
51 |
User | Count |
---|---|
146 | |
107 | |
106 | |
89 | |
65 |