Forum Discussion

JordanJackson's avatar
JordanJackson
Icon for Advocate II rankAdvocate II
3 years ago

DAX measure giving the wrong answer / different answer when in a table compared to a bar chart

I've written to following DAX measure to calculate the current energy system type from different sites: Latest System Types Countx (4) = CALCULATE(     COUNTX('Sites_Energy_and_Water', 'Site...
Need Help
siddhesh_mane's avatar
siddhesh_mane
Frequent Visitor
3 years ago

Hi JordanJackson 

 

Is it possible to provide a sample dataset for this?

 

Thank you,

Siddhesh H Mane.

  • JordanJackson's avatar
    JordanJackson
    Icon for Advocate II rankAdvocate II
    3 years ago
    System Type Measure Region Contract Satalite Name
    Generator + Battery 1 E A  
    Generator + Battery 1 E A 2
    Generator + Battery 1 E B 1
    Generator + Battery + Solar 1 E B 2
    Generator + Battery + Solar 1 E C 1
    Generator + Battery + Solar 1 E D 1
    Hydrogen + Battery 1 E E 1


    Am I needing to add in the Satalite Name context to the measure?