User Profile

FPE5

Regular Visitor

Joined 1 year ago

5 Posts

View All Badges

User Widgets

Contributions

Re: Team share % measure (based on variable) changes in scatterplot to total of all rows
Hi Tayloramy, Thank you for your reply! I've recreated it with some extra fields (which I didnt share like Date), and it works great too. I'm still a bit puzzled on the use of VAR TeamForName = SELECTEDVALUE('Table'[Team]) and the KEEPFILTERS addition to force the team. So I will read into that as well. Thank you for your help 😄
10 months ago Place DAX Commands and Tips
604Views
0likes
0Comments
Re: Team share % measure (based on variable) changes in scatterplot to total of all rows
Thank you, John! This worked like a charm. Thanks aswell for the two links, im gonna dive into these 🙂
10 months ago Place DAX Commands and Tips
638Views
0likes
0Comments
Team share % measure (based on variable) changes in scatterplot to total of all rows
Hi guys, I have got a measure that calculates the teamshare % as in example measure and table below. Team Share % = var PlayerPoints = CALCULATE(sum('Table'[Points])) var TeamPoints = CALCULATE(sum('Table'[Points]),ALLEXCEPT('Table', 'Table'[Team])) Return PlayerTarget/TeamTargets Name Team Points Team share % Pete Red 5 25% John Red 15 75% Hank Blue 10 100% This is all fine, but when I try to get this measure in a scatterplot, with Name as Value and without the Team variable, the Team share % changes and combines all the points from all the Names. So Pete would be 16% (5/30 instead of 5/20). I cant seem to get it to work within a measure. Any tips? Thanks in advance. 🙂
Solved
10 months ago Place DAX Commands and Tips
671Views
0likes
4Comments
Re: Variables that dont respond to filters in dashboard
Not sure why I didnt try that, but your theory works. Thanks for the reply and solution!
1 year ago Place DAX Commands and Tips
433Views
0likes
0Comments
Variables that dont respond to filters in dashboard
Hi all, I have a measure that sums based on week numbers (week nr). Week nr also is a filter in my dashboard, but I cant seem to not make it react with the screenshot below. I've tried using a calculate function with ALL('Date'[Weeknr] in the screenshot, but that doesn't work. What could be a way to make the above screenshot ignore a filter? thanks in advance 🙂
Solved
1 year ago Place DAX Commands and Tips
486Views
0likes
2Comments

Data Privacy

Microsoft Fabric Community and Privacy

To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.