scale
6 TopicsHelp with DAX for Scaled Score Matrix
Hi all, I've been trying to create a DAX measure to generate scaled score (wihout intermediate tables) for a competition but unsuccessful. This is how the end matrix is required in Power BI Scaled Score Team 1 Team 2 Team 3 Cooking 1 0 0.70 Driving 1 0.93 0 Reading 0 1 0.53 Singing 1 0 0 Sports 1 0.36 0 The forumula that is used to calcuate the scaled score: Scaled Score for an Activity = ((Sum of the respective Team's Activity Mins) - (Minimum of Activity Mins across teams)) / ((Maximum of Activity Mins across teams) - (Minimum of Activity Mins across teams)) For e.g., Scaled Score of Team 3 for Cooking = (150-20)/(205-20) = 0.703 This is the source table, named Activity: This table contains the list of activities (with duration in mins) perfomed by each candidate. Team Candidate Name Activity Activity Mins Team 1 Man 1 Singing 90 Team 3 Man 1 Singing 35 Team 2 Man 4 Driving 30 Team 3 Man 2 Reading 80 Team 3 Man 4 Cooking 30 Team 1 Man 2 Reading 65 Team 1 Man 5 Cooking 85 Team 3 Man 5 Cooking 15 Team 1 Man 1 Sports 85 Team 1 Man 4 Sports 75 Team 1 Man 5 Driving 30 Team 2 Man 4 Sports 65 Team 2 Man 3 Sports 25 Team 2 Man 3 Reading 20 Team 1 Man 4 Sports 35 Team 1 Man 3 Singing 75 Team 2 Man 4 Singing 35 Team 3 Man 2 Reading 35 Team 3 Man 4 Driving 30 Team 3 Man 3 Sports 30 Team 2 Man 1 Driving 70 Team 1 Man 4 Driving 75 Team 1 Man 5 Cooking 85 Team 1 Man 5 Cooking 35 Team 3 Man 5 Cooking 50 Team 2 Man 3 Cooking 20 Team 3 Man 5 Cooking 55 Team 2 Man 2 Reading 75 Team 2 Man 3 Reading 65 Team 1 Man 3 Singing 75 This is the measure I wrote after a lot of research, but it isn't working as intended Scaled Score = VAR MinValue = CALCULATE( MINX( SUMMARIZE(Activity, Activity[Team]), CALCULATE( SUM(Activity[Activity Mins]) ) ) ) VAR MaxValue = CALCULATE( MAXX( SUMMARIZE(Activity, Activity[Team]), CALCULATE( SUM(Activity[Activity Mins]) ) ) ) VAR TeamTotal = CALCULATE( SUM(Activity[Activity Mins]), ALLEXCEPT(Activity, Activity[Activity]) ) RETURN DIVIDE(TeamTotal - MinValue, MaxValue - MinValue, 0) Any help in getting the DAX measure is appreciated. Thanks in advance!Solved863Views0likes2CommentsPower BI Report Server - Scalability, Load Balancing, Clustering & HA, Encryption
Hi all, Good day. Faily new to this Power BI Report Server game, would appreciate if you can assist on the following query. Is Power BI Report Server works the same way as SSRS, in term of scalability, load balancing, clustering and HA, as well as data encryption? I have seaerched through the community, able to gathered the following informing, but mainly on SQL server or SSRS. Do we have any document/link that is focus on Power BI Report Server with the required information? Thanks. HA https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/reporting-services-with-always-on-availability-groups-sql-server?view=sql-server-ver15#bkmk_reportserverdatabases https://docs.microsoft.com/en-us/sql/database-engine/sql-server-business-continuity-dr?view=sql-server-ver15 Scale out https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/configure-a-native-mode-report-server-scale-out-deployment?view=sql-server-ver15 https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/ms159114(v=sql.105)?redirectedfrom=MSDN https://docs.microsoft.com/en-us/power-bi/report-server/capacity-planning Data Encryption https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/ssrs-encryption-keys-initialize-a-report-server?view=sql-server-ver152.5KViews0likes1CommentHelp! How to configure a ScaleOut for a Data model Refresh
Hi All, We need to have the following configuration with 2 servers where PBIRS is installed : The first one acts as a Front-End server (interactive report processing) The second one acts as a back-End server, in particular it accepts all the data model refresh requests (scheduled report processing). On the PBIRS confirmation of each server, the scale out section contains both servers Question is: How can we force that the first one is used for interactive report processing and the second one will perform the data model refresh? Microsoft documentation is the following (but not clear to me): https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/configure-a-native-mode-report-server-scale-out-deployment?view=sql-server-ver15 Thanks for your help! KarimSolved1.1KViews0likes1CommentHow to scale out Power BI Report Server?
Hi, How can I scale out Power BI Report Server? I am running an instance on a VM and have added 8 cores to the instance but Report Server is still only running off one of the cores with no performance boost. What am I missing? Do I need to change something in the .config files? thanks, MattSolved11KViews0likes4Comments