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 dis...
Show and Tell
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