Forum Discussion
verma_isha02
3 years agoFrequent Visitor
Need help with DAX measure
HI All, I have a table like below in Power BI - I need help in creating DAX calculation where as an example for Germany, I would need - Value in collumn B - MIN(Value in column b for the c...
- Anonymous3 years ago
Hi, verma_isha02 ,
Here I create a sample to have a test.
I think A/B/C may be measures.
Measure:
Measure = VAR _PART1 = [B] VAR _1 = SUMMARIZE ( ALL ( 'Table' ), 'Table'[Country], "B", [B] ) VAR _2 = ADDCOLUMNS ( _1, "MINVALUE", MINX ( FILTER ( _1, [B] < EARLIER ( [B] ) && [B] <> 0 ), [B] ) ) VAR _PART2 = SUMX ( FILTER ( _2, [Country] = MAX ( 'Table'[Country] ) ), [MINVALUE] ) RETURN DIVIDE ( ( _PART1 - _PART2 ) * [C], [A] )Result is as below.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
lbendlin
Super User
3 years agoPlease provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523