Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
hello guys,
i have a problem that is soooo frustrating to me,
whenever i copy a DAX code that uses a variable table, then reference a column of this variable table inside another variable it works so fine for them, but when i tried to use the same syntax, it just doesn't work for me ?!!!!!!!
Driving me crazy !!!!!!!!
what is wrong here ?!!!
VAR SourceTable = ADDCOLUMNS ( ALL ( Sales[ItemCode] ), "@Amt", [Sum of Net Sales Value] )
VAR Result = RANK ( DENSE, SourceTable, ORDERBY ([@Amt], DESC) )
VAR _Table = ADDCOLUMNS ( ALL ( Sales[ItemCode] ), "@tank", RANKX ( ALL ( Sales[ItemCode] ), [Sum of Net Sales Value],, DESC, DENSE))
VAR _DisCount = DISTINCTCOUNT(_Table'[2tank])
RETURN Result & " OF TOTAL " &_DisCount
Solved! Go to Solution.
Normal aggregation functions do not work with variable tables. You need to use x-aggegator. Try
VAR _DisCount =
MAXX ( _Table, [@Rank] )
Thank you so much, that was helpful...
Normal aggregation functions do not work with variable tables. You need to use x-aggegator. Try
VAR _DisCount =
MAXX ( _Table, [@Rank] )
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.