User Profile
ES335Cherry
Frequent Visitor
Joined 1 year ago
User Widgets
Contributions
Re: Measure is returning BLANK
FBergamaschi, I am giving you credit for the resolution as it steered me in the direction of finding the problem. There were gaps in records due to data entry which caused blanks at many dates. I should have included code in my DAX to prevent missing data from causing that level of issue(s). - Doug1.3KViews0likes0CommentsRe: Measure is returning BLANK
FBergamaschi , I understand the need for the requested data but the gaming commission would never sing off on posting or even providing that information privately. Obfuscating the actual numbers may scew the evalution and would not be helpful. Thanx anyway. - 3351.5KViews0likes1CommentMeasure is returning BLANK
Ultimately, I am wanting AVERAGE sum of win per month divided by average number of open tables per month I have a T-SQL routine that works swimmingly where I figure the average win MTD by summing for the month, then dividing by the number of days in the month. I then divide by the average number of open tables during the month and then my visualizer slices by game type (Blackjack, Craps etc.) I need to implement the previously describe login in a measure, or measures, but I am receiving a BLANK using the following manor. I am wanting avage win, month-to-date, per table game. I have the following … MEASER: win_MTD = CALCULATE(Sum(TG_DataFrom_FLASH[win]), DATESMTD(GamingDatesList[GamingDatesList])) MEASER: avgWinMTD = CALCULATE(DIVIDE([win_MTD], Sum(GamingDatesList[DayNum]))) MEASURE: WinPerUnitDay = CALCULATE(DIVIDE(SUM(TG_DataFrom_FLASH[win]), sum(TG_DataFrom_FLASH[TableCount]))) *********************************************************************************************** Main MEASURE: WPUMTD = VAR WinUnit_MTD = CALCULATE(Sum([WinPerUnitDay]), DATESMTD(TGDataFromFlashRecap[GamingDate].[Date])) VAR AvgWinUnit = CALCULATE(DIVIDE(WinUnit_MTD, DATESMTD(TGDataFromFlashRecap[GamingDate].[Date]))) VAR TableCountMTD = CALCULATE(SUM(TG_DataFrom_FLASH[TableCount]), DATESMTD(GamingDatesList[GamingDatesList])) VAR avgTableCountMTD = CALCULATE(DIVIDE(TableCountMTD, sum(GamingDatesList[DayNum]),0)) VAR finaloutput = CALCULATE( DIVIDE(AvgWinUnit, avgTableCountMTD)) RETURN finaloutput ******************************************************************************************************Solved1.5KViews0likes7CommentsDax Studio - cannot change connection
I have just installed DAX Studio and connected to a Power BI Desktop. I wish to use a DIFFERENT power BI project but DAX Studio does not seem to allow changeing the connection. I have tried closeing and reopenning Dax Studio. I have searched the documentation on the Dax Studio web site.Solved1.2KViews2likes4Comments
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.