Forum Discussion

AllanBerces's avatar
AllanBerces
Post Prodigy
1 year ago
Solved

Sum base from two column

Hi good day, Can anyone help me to correct my measure. I want to calculate the sum of NPT base from two column trade and specific type.   CALCULATE( SUM('Table'[NPTHrs]), Table[Type] =  "Non-pro...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi AllanBerces 

     

    Thanks for the reply from wini_R .

     

    Due to some security policy, I can't open your link. From your formula, my suggestion is that you can try to remove ALL.

     

    For more details about ALL function,  you can read related document link:

    ALL function (DAX) - DAX | Microsoft Learn

     

    If you need further help, could you please consider showing your PBIX in the following form?

    How to provide sample data in the Power BI Forum - Microsoft Fabric Community

     

    Best Regards,
    Yulia Xu

     

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

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi AllanBerces 

 

Thanks for the reply from wini_R .

 

Due to some security policy, I can't open your link. From your formula, my suggestion is that you can try to remove ALL.

 

For more details about ALL function,  you can read related document link:

ALL function (DAX) - DAX | Microsoft Learn

 

If you need further help, could you please consider showing your PBIX in the following form?

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

 

Best Regards,
Yulia Xu

 

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

AllanBerces's avatar
AllanBerces
Post Prodigy
1 year ago

Hi Anonymous thank you very much for the reply working perfectly.