Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi, i've looked at a couple of similair posts but can't seem to figure out how to solve this. I have a measure which gives me the lowest value between the sum of a value AND another value. Here's the measure:
Solved! Go to Solution.
At GT is calculated again, you need to group data at some level like
sumx(summarize(table1,table1[View 1],table[View 2],"_sum",CALCULATE(MIN(SUM(table1[value1]), MIN(table2[value2])
))),[_sum])
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges
Connect on Linkedin
At GT is calculated again, you need to group data at some level like
sumx(summarize(table1,table1[View 1],table[View 2],"_sum",CALCULATE(MIN(SUM(table1[value1]), MIN(table2[value2])
))),[_sum])
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges
Connect on Linkedin
Hi Amit,
Thanks for your reply. I'm having a bit of trouble understanding what [View 1] and [View2] is. You also use 'table[View 2]' which i'm not sure about because I don't have a 'table' called 'table'.
As I don't know where you want to group data, I kept view and view 2 for that. It can only 1 or 2 or any number
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
89 | |
84 | |
76 | |
64 |
User | Count |
---|---|
135 | |
112 | |
98 | |
98 | |
92 |