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.
Hi, I have below dataset and table visual.
I got incorrect total from 'Price-GST(Wrong)' measure.
Price-GST(wrong) =
VAR withoutGST = SUM('Table'[Price])
VAR withGST = SUMX(VALUES('Table'[ID]),withoutGST/1.1)
RETURN
IF(SELECTEDVALUE('Table'[GST])=0,withoutGST,withGST)
So I researched and was able to have the correct total from 'Price-GST(Correct)' mesaure.
Price-GST(correct) = SUMX(VALUES('Table'[ID]),[Price-GST(wrong)])
However, i tried to combine those 2 measures into one using VAR but couldn't get what I wanted. Is there any way I can use one measure and still get the correct total?
Solved! Go to Solution.
Hi,
Please try the below measure.
New measure: =
SUMX (
ADDCOLUMNS (
VALUES ( Data[ID] ),
"@condition",
IF (
CALCULATE ( SELECTEDVALUE ( Data[GST] ) ) = 0,
CALCULATE ( SUM ( Data[Price] ) ),
CALCULATE ( SUM ( Data[Price] ) ) / 1.1
)
),
[@condition]
)
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.
Hi,
Please try the below measure.
New measure: =
SUMX (
ADDCOLUMNS (
VALUES ( Data[ID] ),
"@condition",
IF (
CALCULATE ( SELECTEDVALUE ( Data[GST] ) ) = 0,
CALCULATE ( SUM ( Data[Price] ) ),
CALCULATE ( SUM ( Data[Price] ) ) / 1.1
)
),
[@condition]
)
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.
It works well! Thanks a lot.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |