topic Re: Dax measure query required of below shared expressions. kindly help me! in DAX Commands and Tips

Dax measure query required of below shared expressions. kindly help me!

Anonymous — Tue, 21 Jan 2025 12:00:26 GMT

Hi Team,
Good Afternoon!
Kindly help me for DAX measure query of below 2 expressions.

1. Sum([ABC] * [DEF] / 100)

2. Sum((case when [AAA]>1 then [AAA] / 100 else [AAA] end) * [XYZ]) / Sum((case when [BBB]>1 then [BBB] / 100 else [BBB] end) * [XYZ])

I required measures due to need to call this final values in the card visual. please help me.

Re: Dax measure query required of below shared expressions. kindly help me!

SachinNandanwar — Tue, 21 Jan 2025 12:51:23 GMT

Can you post some sample data and the expected output ?

You can try the following to get started :

YourMeasur1 = SUMX(Tbl,(Tbl[ABC]*Tbl[DEF])/100) YourMeasure2 = Var _val1= SUMX(Tbl,If(Tbl[AAA]>1,Tbl[AAA]/100,Tbl[AAA])*Tbl[XYZ]) Var _val2= SUMX(Tbl,If(Tbl[AAA]>1, Tbl[AAA]/100,Tbl[AAA])*Tbl[XYZ]) RETURN DIVIDE(_val1/_val2 )

Re: Dax measure query required of below shared expressions. kindly help me!

BeaBF — Tue, 21 Jan 2025 12:59:04 GMT

Anonymous Hi!

Measure 1:

Measure1 = SUMX(
TableName,
([ABC] * [DEF]) / 100
)

Measure 2:

Measure2 =
DIVIDE(
SUMX(
TableName,
(IF([AAA] > 1, [AAA] / 100, [AAA]) * [XYZ])
),
SUMX(
TableName,
(IF([BBB] > 1, [BBB] / 100, [BBB]) * [XYZ])
),
0
)

If it's ok, please accept the answer as solution

BBF

Re: Dax measure query required of below shared expressions. kindly help me!

Anonymous — Wed, 22 Jan 2025 08:06:14 GMT

Hi, Anonymous
Thanks for reaching out to the Microsoft fabric community forum.

Could you please confirm if BeaBF and SachinNandanwar 's responses have resolved your issue? If they have, you might consider accepting their responses as the solution, which will help others find answers more quickly.

Logically, their responses are the most effective and concise solutions. However, since we are unsure whether [AAA], [XYZ], and [BBB] in your requirement refer to measures or fields, if they are measures, the provided solutions might have some limitations. Therefore, I hope you can confirm whether their responses are effective. If not, please share your data structure, the composition of your measures, and answer my questions. This will help us brainstorm more effectively for your issue.

We recommend using GitHub or SharePoint to share your files with us.When uploading a file, please be careful to delete sensitive information. Looking forward to your response.

For questions about uploading data, you can try the following links:

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Of course, if you have any new discoveries or questions, please feel free to get in touch with us.

Best Regards,

Leroy Lu

Re: Dax measure query required of below shared expressions. kindly help me!

Kedar_Pande — Wed, 22 Jan 2025 10:25:35 GMT

Anonymous

Measure1 = SUMX(YourTable, [ABC] * [DEF] / 100)

Measure2 =
DIVIDE(
SUMX(
YourTable,
IF([AAA] > 1, [AAA] / 100, [AAA]) * [XYZ]
),
SUMX(
YourTable,
IF([BBB] > 1, [BBB] / 100, [BBB]) * [XYZ]
)
)

💡 If this helped, please give Kudos 👍 or mark it as a Solution ✅.
Best regards,
Kedar
🌐 Connect on LinkedIn

Re: Dax measure query required of below shared expressions. kindly help me!

Poojara_D12 — Thu, 23 Jan 2025 08:36:37 GMT

Hi Anonymous

Can you please try this dax:

Measure_1 = SUMX('TableName', 'TableName'[ABC] * 'TableName'[DEF] / 100)

Measure_2 = DIVIDE(
SUMX('TableName', IF('TableName'[AAA] > 1, 'TableName'[AAA] / 100, 'TableName'[AAA]) * 'TableName'[XYZ]),
SUMX('TableName', IF('TableName'[BBB] > 1, 'TableName'[BBB] / 100, 'TableName'[BBB]) * 'TableName'[XYZ])
)