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

      Hello Vvelarde,

       

      Would you be available as a paid consultant to complete a few reports we are developing in Power BI?

       

      Would be happy to pay you for your time. 

      • v-micsh-msft's avatar
        v-micsh-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        9 years ago

        Hi lcasey,

         

        What is your current situation?

        If you still need any further assistance on this topic, then please post back and we will see what we could suggest.

        In addition, if you are using SSRS 2016, then it would be possible to PIN dashboard directly from SSRS to Power BI.

        Pin Reporting Services items to Power BI Dashboards

        Regards

  • 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!!!