Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Kavya123
Helper III
Helper III

DAX expression using specific field

Hi Everyone,

 

Please help me to write expression in DAX.

 

My current expression is Sum( Value) . I want to display the value based on specific field  Response Type.

 

For ex: 1.If Responsetype is ###,###,###,##0.0% then value would be 104,336.8%

2. If Responsetype is ###,###,###,##0  then Value is 10,972  (without percentage)

 

Response Type

###,###,###,##0
###,###,###,##0%
###,###,###,##0.0
###,###,###,##0.0%
###,###,###,##0.00
###,###,###,##0.00%
$###,###,###,##0
$###,###,###,##0.00

 

Thanks in advance

 

1 ACCEPTED SOLUTION
josef78
Memorable Member
Memorable Member

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... 🙂

View solution in original post

4 REPLIES 4
josef78
Memorable Member
Memorable Member

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... 🙂

Thank you so much for your help.

FarhanAhmed
Community Champion
Community Champion

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

 

 

 







Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!




Thanks for your response.

 

I want to format based on specific field Responsetype.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.