s

3 Topics

Do I still need a Pro/Premium license if I have a Report Server subscription?
I'd like to share my dashboards with internal members of the department but was told by my organization head that sharing permissions can't be granted to me because this isn't a feature. They also mentioned they only support SQL connections, but I'm not sure if they have a SQL Enterprise license as part of the report server subscription. From what I've seen, it looks like dashboards are being shared internally (members log in via their company credentials to view the dashboards). If I have the report server subscription, do I still need a pro/premium license to share dashboards?
Solved
Anonymous
4 years ago Place Report Server
2.7KViews
0likes
8Comments
How to find sum of max values in a column and filter it?
I have a table that has mutiple values of "OPCount" as rows for each Faciliy name and each date. So i am summing them up to show the max for each day for each facilty. Below is what i am using to summarize my rows(Please tell me if this is correct): 1OPCount = IF( -- NORMAL LINE--- MAXA(Query1[OPCount]), -- TOTAL LINE --- SUMX( VALUES('Query1'[InvDate1]), CALCULATE( MAXA(Query1[OPCount]) ) ) ) This is how i get my values - ie: max of among the rows. Butt, I need it to show as total of each column. Can you'll suggest a better way to do this so that i clearly get the total of each column whatever filter i may use?
Solved
FeezaAga
6 years ago Place Desktop
5KViews
0likes
11Comments
DAX performance. Lots of what if parameters affecting measures.
Hi all, I have a Power BI file with a tab where there are 14 segmentations (14 what if parameters) and I have a measure that use all those segmentations: This is the measure I have: ------------------------------------------------ INCENTIVE FEE_TRAMO = var agop_por = SELECTEDVALUE('%AGOP'[Value]) var por_min = SELECTEDVALUE('%min'[Value]) var por_int = SELECTEDVALUE('%int1'[Value]) var por_int2 =SELECTEDVALUE('%int2'[Value]) var por_max = SELECTEDVALUE('%max'[Value]) var IF11 = SELECTEDVALUE(IF1[Value]) var IF22 = SELECTEDVALUE(IF2[Value]) VAR IF33 = SELECTEDVALUE(IF3[Value]) VAR IF44 = SELECTEDVALUE(IF4[Value]) VAR IF55 = SELECTEDVALUE(IF5[Value]) return SWITCH(TRUE(); agop_por<por_min || [G.O.P_TOT %]<por_min;IF11 ; (agop_por> por_min && agop_por<por_int) || ([G.O.P_TOT %]> por_min && [G.O.P_TOT %]<por_int);IF22; (agop_por>por_int && agop_por< por_int2) ||([G.O.P_TOT %]>por_int && [G.O.P_TOT %]< por_int2);IF33; (agop_por>por_int2 && agop_por< por_max) ||([G.O.P_TOT %]>por_int2 && [G.O.P_TOT %]< por_max) ;IF44; agop_por>por_max|| [G.O.P_TOT %]>por_max;IF55) ------------------------------------------------------------- The problem is that when I change any of the what if parameters values it takes almost 2 minutes to update the visual.. how can I make more optimized my measure? (G.O.P_TOT % is another measure from another table) Thank you in advance. Andrea.
Solved
Anonymous
6 years ago Place DAX Commands and Tips
2.3KViews
0likes
5Comments