Forum Discussion
beeEc009
3 years agoRegular Visitor
DAX- Return a value based on two columns
Hi all, I'm new to DAX and am trying to create a measure for a large report. I have multiple (About 1000) states names & Ids with data names (about 10), Ids and values. I have created a sma...
amitchandak
3 years agoSuper User
beeEc009 , a new meausre
divide(Sum(Table[Value]), calculate(Sum(Table[Value]), Table[Data Name] ="Amm Rate") )