Forum Discussion
mosman
6 years agoFrequent Visitor
Min and Max Measures are wrong
I have a dashboard with minimum and maximum balance. Here is Dax for Max Balance: Maximum Balance = VAR _mb = CALCULATE ( MAX ( vw_inactive_account_shares[share_balance_amount] ) ) RETURN I...
- 6 years ago
Your max/Min is your line-level max or Min. And you are grouping data by a particular category. If means the balance is summed up.
Make your balance or some other field as un summarized or add a line-level key and check.
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 - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
Ashish_Mathur
Super User
6 years agoHi,
Share a simple dataset and show the expected result.