Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Aggregate a Calculated Measures

Hello everyone. I have created a measure that does exactly what I need it to do which is show an image based on the number.    Availiability KPI* = SUMX(ResourceTimephasedDataSet, ResourceTimephas...
General Comment
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    I found my solution, took me 4 days to come up with this but I got it. I also had to do it for each case. I hope this will be able to help someone else in the future.

    Availiable KPI Ok = COUNTX( DISTINCT(ResourceTimephasedDataSet[Resource ID]), IF(ResourceTimephasedDataSet[Availability KPI*] > -20 && ResourceTimephasedDataSet[Availability KPI*] <= 20, 1))
Ashish_Mathur's avatar
Ashish_Mathur
Super User
4 years ago

Hi,

You do not need the SUMX.  A simple SUM function should do.

Availiability KPI* = SUM(ResourceTimephasedDataSet[Availability])

I think i canbring about some more improvements.  Please share the link from where i can download your PBI file.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Availability is also a a measure, do you think a simple sum will still work?

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      4 years ago

      Ideally measures hould never be prceeded with the Table name.  That is why i suggested a SUM function.  If it is a measure, thena SUMX would be required.

      Availiability KPI* = SUMX(ResourceTimephasedDataSet,[Availability])
      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        I agree, for some reason my Power BI desktop on my computers started adding the table name. If you know how to turn it off, please let me know.