Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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.
Regards
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |