Forum Discussion

lcasey's avatar
lcasey
Icon for Post Prodigy rankPost Prodigy
9 years ago

Power BI is Not summing up correctly

Hello,   I have found that Power BI does not Accuratley summarize columns in the Table Matrix.     First Column:    Balance USD = IF('BSA00-RMMC'[RMDTYPAL]<7,'BSA00-RMMC'[ORTRXAMT],IF(ISBLANK('B...
Need Help
Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
9 years ago

lcasey

 

The issue is the [EXCHRATETOUSE]  when is all customer selected (Total) his value is blank.

 

To solve this create another measure [EXCHRATETOUSE2] and Add before the last ) this ,1

 

Use [EXCHRATETOUSE2] in your second measure

lcasey's avatar
lcasey
Icon for Post Prodigy rankPost Prodigy
9 years ago

Thanks!

 

I see that I need to get studying DAX language. I am not really understanding this, I develop many reports in SSRS and Power BI is completely different.  I can Understand some SQL language but this language is like trying to learn Chineese...:)

 

I am going to finish all my calculations so that Users can export the dataset into Excel and perform the calculation in Excel. 

 

I guess I will need to carefully go through any books and online help with DAX , as all the suggestions here are absolutely correct and will fix the issue, I just have no concept of the hasonefilter or hasonevalue DAX function. I cant wrap my head around it at the moment.

 

I wonder if I would have a better career learning the Chineese Language...:)  Might be a little easier...:)

 

Thanks For all your help!!!