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,
I'm new to the community and I'm experiencing an unexpected error in Power BI. I'm working for a client and going through their sales data, which is split by regions.
As I would like to compare the sales volume in one region to the sales volume of all regions except that one across time I've built a line chart visualization with date on the x axis and the following values:
- Values:
If you could use this formula as below:
Volume (Excl. A) = CALCULATE(Sales[Total Volume],Sales[Region]<>"A")
or
Volume (Excl. A) = CALCULATE(Sales[Total Volume],FILTER(Sales,Sales[Region]<>"A"))
If not your case, could you please use dummy data to do a simple sample pbix file and share it and your expected output, that will be a great help.
Regards,
Lin
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Hi Greg,
Thank you. Unfortunately I cannot post the sample data as it's client data and I've signed a NDA :(, otherwise I would have...
Best,
G
Hi @giacomoghezzi ,
First of all try to change your measure to:
Volume (Excl. A) = SUMX(FILTER(Sales, Sales[Region]<> "A" ),[Total Volume]))
This may be related with a variety of issues from missinformation in your database to syntax in formula, to relationships.
Probably you need to go and filter out information what I ussualy do with this cases is place the information in a table and then start to add details, in your case sales region, dates, .... and so on until you get the detail of what is having impact on your calculation.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThank you,
I'll give that a try!!
Does the above reply helps. Else create a sample data and sample output in table format and provide.
make me @
Appreciate your Kudos.
can you share a snapshot or power bi file
Hi Yogeshmaney,
Thanks for your reply. Unfortunately I can't as it's sensitive data :(.
Best,
Giacomo
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |