User Profile
Juan_Quikin5
Frequent Visitor
Joined 4 years ago
User Widgets
Contributions
Decimal formats varying in table and card visuals
Hi guys! I have the regional settings of my current file in "English (United States)." However, the auto-display units in my visual card are not matching the format of the following measure for a table visual: SellOut = VAR calc = [MGMV] var decimals = "0.0" RETURN SWITCH ( TRUE() , calc > 1000000 , FORMAT ( calc / 1000000 , "$" & decimals & "M" ) , calc > 1000 , FORMAT ( calc / 1000 , "$" & decimals & "K" ) , FORMAT ( calc , "$" & decimals ) ) The card takes a comma as a decimal separator while the table takes a dot as a decimal separator. I tried changing the "VAR decimals" part to "0,0", but this format is adding a zero to left whenever the value has just one digit (e.g. $06K) Any idea would be very appreciated! Thanks guys!Calculating row subtotals differently
Hi guys I have the following matrix with three measures. Mi INVESTMENT measure is defined as: INVESTMENT = VAR RES = [Sell Out] * [% INV] VAR RESULT = IF (HASONEFILTER ( Table[Company] ), IF ( [% INV] > 0, RES, BLANK () ), SUMX ( FILTER ( Table, [% INV] > 0 ), RES ) ) RETURN RESULT However my desired subtotal is just the sum of the investment values of each company: 11,5 + 18,6 + 14,3. Any idea would be very appreciated!Report fast in one workspace and slow in other one
Hi, I work at a company that has several workspaces. I have a report initially published in one workspace and it ran very fast. However when I publish the same exact report in other workspace it runs slower and takes too long to switch between pages. Any help would be very appreciated!!
