Forum Discussion

Wise1's avatar
Wise1
Icon for Helper I rankHelper I
9 years ago

DAX Formula for subtracting

Hello All,   I have been trying to figure the following out for the last 2 days without any luck,    Basiclly what iam trying to achieve is  Client - has allocated 10 hours a month 4 hrs worth ...
Need Help
Wise1's avatar
Wise1
Icon for Helper I rankHelper I
9 years ago

Hello,

 

Just wondering if there was a way to list the value (Rather then sum it up) 

 

 

Ie:   SLAHours = Sum(sla[SLA Hours]) (this adds up the allocated hours together) 

 

is it possible to use something to list the data, like ALL, Datatable, etc? 

 

Thanks!

wynhopkins's avatar
wynhopkins
Icon for Most Valuable Professional rankMost Valuable Professional
9 years ago

Can you explain what you are trying to achieve by listing the values

 

If you want a table to show all the unique values then you could drag sla(SLA Hours) into the Rows section of a Matrix visualisation?