Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Pie Graph not interacting with card

Hi everyone,   I received an already worked powerbi Model, I'm not that comfortable with the data base that it's using but i'm trying to make it work, I've searched other posts with no luck since I...
Need Help
VahidDM's avatar
VahidDM
Icon for Super User rankSuper User
4 years ago

Hi Anonymous 

 

Can you share the measures that you used to set up the card? Did you use any All, removefilters,.... dax formulas in those measures to ignore the filter by PAX names?

Appreciate your Kudos!! 

LinkedIn | Twitter | Blog | YouTube 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Vahid!

 

Measures I've tried different options for the measures of the card:

 

Opt 1.  SUM X of the 2 columns

"Pax Totales = SUMX('Indicadores AIT','Indicadores AIT'[PAX AV COMERCIAL] + 'Indicadores AIT'[PAX AV GENERAL])"

 

Opt. 2 the sum of two measures (which are the ones that I use for the PIE GRAPH)

 

Pie Graph Measure 1 (Sum of column 1) = 

Pax general = SUM('Indicadores AIT'[PAX AV GENERAL])
 
Pie Graph Measure 2 (Sum of column 2)=
Pax comercial = SUM('Indicadores AIT'[PAX AV COMERCIAL])
 
Therefore mi card measure would be Measure 1 + measure 2
 
Note: I have also tried to make the pie graph only dragging column values instead of the measures