cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

## Divide function returns blank for row totals and card visuals

Please may I get help understand whats wrong with my dax , that it returns blank when used on card visual but displays value in table.

1 ACCEPTED SOLUTION
Super User

Hi, I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

Score Q1: =
VAR _t =
SUMMARIZE ( Data, Data[Question 1] ),
"@count", CALCULATE ( COUNT ( Data[Question 1] ) ),
"@weight",
CALCULATE (
SWITCH (
TRUE (),
SELECTEDVALUE ( Data[Question 1] ) = "Excellent", 5,
SELECTEDVALUE ( Data[Question 1] ) = "Very good", 4,
SELECTEDVALUE ( Data[Question 1] ) = "Good", 3
)
),
"@denom", CALCULATE ( COUNT ( Data[Question 1] ), ALL ( Data ) ) * 5
)
RETURN
IF (
HASONEVALUE ( Data[Question 1] ),
DIVIDE ( SUMX ( _t, [@weight] * [@count] ), SUMX ( _t, [@denom] ) ),
DIVIDE ( SUMX ( _t, [@weight] * [@count] ), COUNT ( Data[Question 1] ) * 5 )
)

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

2 REPLIES 2
Super User

Hi, I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

Score Q1: =
VAR _t =
SUMMARIZE ( Data, Data[Question 1] ),
"@count", CALCULATE ( COUNT ( Data[Question 1] ) ),
"@weight",
CALCULATE (
SWITCH (
TRUE (),
SELECTEDVALUE ( Data[Question 1] ) = "Excellent", 5,
SELECTEDVALUE ( Data[Question 1] ) = "Very good", 4,
SELECTEDVALUE ( Data[Question 1] ) = "Good", 3
)
),
"@denom", CALCULATE ( COUNT ( Data[Question 1] ), ALL ( Data ) ) * 5
)
RETURN
IF (
HASONEVALUE ( Data[Question 1] ),
DIVIDE ( SUMX ( _t, [@weight] * [@count] ), SUMX ( _t, [@denom] ) ),
DIVIDE ( SUMX ( _t, [@weight] * [@count] ), COUNT ( Data[Question 1] ) * 5 )
)

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Helper I

Thanks, I understood the issue

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.