Solved: Re: Need DAX help

Happy2023_05 · ‎10-25-2022

Country field has 1 indicator field X.

X has Boolean values-true or false

Country. X

C1. True

C2. False

C3. True

If country slicer(C2) selected indicator is false it should show 0 in card not blank. Suppose none of the country slicer is selected it should show value as 2.(because C1 & c3 has true)

Want to show in card visual.

How to achieve in DAX?please help

Jihwan_Kim · ‎10-25-2022

Hi,

Please check the below picture and the attached pbix file.

expected measure: =
SUMX ( Country, Country[X] * 1 )

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.

Go to My LinkedIn Page

View solution in original post

Jihwan_Kim · ‎10-25-2022

Hi,

Please check the below picture and the attached pbix file.

expected measure: =
SUMX ( Country, Country[X] * 1 )

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.

Go to My LinkedIn Page

Happy2023_05 · ‎10-26-2022

It worked.Thank you so much for the help.

Need DAX help

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024