Forum Discussion
DAX expression using specific field
Hi,
maybe try another forum group, like DAX commands and tips, bacause this is related on onpremise report server deployment, but....
...if you need sum, it is measure, you must solve how aggregate multiple formats to single result ... you can try:
if(HASONEVALUE([Responsetype]),format(SUM([Value]),FIRSTNONBLANK([Responsetype],1)),blank())
it will format sum of coumun based on format string in another columns, and in case multiple formats (e.g. last total row in visualisation) is returned blank value. But maybe found better approach, I'm not DAX expert... 🙂
You may need to create CASES for each response type and try to use FORMAT DAX expression to convert your values in the specified format.
https://docs.microsoft.com/en-us/dax/format-function-dax
https://docs.microsoft.com/en-us/dax/switch-function-dax
Thanks for your response.
I want to format based on specific field Responsetype.
