Forum Discussion

jaymanivannan's avatar
jaymanivannan
Frequent Visitor
9 years ago
Solved

Calculated Measure with conditions

Hi, I am new to PowerBI. I am trying to create a calculated measure based on the condition. For Example, I am trying to create measure for the following condition   SalesAverage= ((SUM(Total Sales...
  • Anonymous's avatar
    Anonymous
    9 years ago

    jaymanivannan response is great.  To add to this, rather than using the / symbol and have to make a divide by zero check, just use the Divide() function.  I've also set this out using a spacing format, which is a good habit to get yourself into.

    Here is an update

    SalesAverage = DIVIDE(
        CALCULATE(
                SUM(Total Sales $), 
                [AccountCode]=410000
        ),
        CALCULATE (
                Sum(Total Sales Quantity), 
                [AccountCode]=420000
        )
)

     

     

ericOnline's avatar
ericOnline
Post Patron
6 years ago

Thanks for the reply Anonymous , but I'm not sure how that function would help. I'm attempting to grab a column from a Table vis that the user has selected. Then use that column as a variable for a measure. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

     Ok i definately misunderstood.  I dont believe there is a dax can interact with visual selections so directly.  You might need to use indirect methods such as HASONEFILTER.