Forum Discussion

ye348's avatar
ye348
Frequent Visitor
4 years ago
Solved

help with calculated columns

im running into an issue trying to get this calculated column to properly display return unique values from a column on another table the formula in this column of this table just counts the r...
Need Help
  • ye348's avatar
    ye348
    4 years ago

    Thank you for taking the time to try an anwser my confusing question, i actually ended up figuring out what the problem was basically in the formula instead of the countrows function i needed to use a sum function instead like so: 

    MWET_Act =
    CALCULATE(
    sum('EXPORT - HVAC WET (PJM)'[length]),
    FILTER('EXPORT - HVAC WET (PJM)', 'EXPORT - HVAC WET (PJM)'[install date] = 'MWET Install'[Value]))
     
    the only reason I kept getting errors was because the column that had the length data that I wanted to sum was being imported as text instead of numbers, asoon as i made that change to the imported length data and catagorized it as decimal numbers the formula i wrote worked.
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi ye348 ,

 

Not very clear.

I have built a data sample and use your DAX to create  FPS_Act column in Table2.

 

If you are still confused about it, please provide me with more details about your table and your expected output or share me with your pbix file after removing sensitive data.

Refer to:

How to Get Your Question Answered Quickly - Microsoft Power BI Community

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

 

 

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

ye348's avatar
ye348
Frequent Visitor
4 years ago

Thank you for taking the time to try an anwser my confusing question, i actually ended up figuring out what the problem was basically in the formula instead of the countrows function i needed to use a sum function instead like so: 

MWET_Act =
CALCULATE(
sum('EXPORT - HVAC WET (PJM)'[length]),
FILTER('EXPORT - HVAC WET (PJM)', 'EXPORT - HVAC WET (PJM)'[install date] = 'MWET Install'[Value]))
 
the only reason I kept getting errors was because the column that had the length data that I wanted to sum was being imported as text instead of numbers, asoon as i made that change to the imported length data and catagorized it as decimal numbers the formula i wrote worked.