Forum Discussion

Mister_T's avatar
Mister_T
Advocate I
5 years ago
Solved

[DAX Measure] Correct values, but wrong total

Dear Community, again, I am lost in the depth of Power BI and DAX. Any help greatly appreciated! I have the following table 'Sales':   Deal ID Deal Closed Deal Won Reseller ...
Need Help
  • ERD's avatar
    ERD
    5 years ago

    Hi Mister_T ,

    Create a second measure:

     

    #Result = 
IF(HASONEVALUE('Sales'[Reseller]),
[COUNT_Reseller_Lost],
SUMX(VALUES('Sales'[Reseller]), [COUNT_Reseller_Lost])
)

     

    If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.

ERD's avatar
ERD
Community Champion
5 years ago

Hi Mister_T ,

Create a second measure:

 

#Result = 
IF(HASONEVALUE('Sales'[Reseller]),
[COUNT_Reseller_Lost],
SUMX(VALUES('Sales'[Reseller]), [COUNT_Reseller_Lost])
)

 

If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.

Mister_T's avatar
Mister_T
Advocate I
5 years ago

Thank you ERD!

 

Works like a charm! 🙂

Thanks again for your help! Greatly appreciated.