Forum Discussion

abhi123's avatar
abhi123
Frequent Visitor
9 years ago

Dax

Hi All,

 

As i am new to power BI. I have to make one measure which shows the MonthWise Sales without putting date into the values shelf.

 

Whatever the Measure we are going to create it will display the MonthWise Sales except "une" sale.

 

Thanks in Adv!!!!!...

 

Abhi.

Show and Tell

1 Reply

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    9 years ago

    Hi abhi123,

     

    If I understand you correctly, the formula to create the measure should be similar like below.

    Measure =
CALCULATE (
    SUM ( 'YourTableName'[MonthWise Sales] ),
    FILTER ( ALL ( 'YourTableName' ), 'YourTableName'[columnName] <> "une" )
)

    If that isn't the case, could you post your table structures with some sample data and your expected result? So that we can better assist on the issue.:smileyhappy:

     

    Regards