Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Chart with number boolean

Hi,   My dataset is a calendar of this kind :   For each date i have the year and boolean opendays I would like to create a graph which count the number of open days by year like Excel : ...
Need Help
  • v-diye-msft's avatar
    v-diye-msft
    6 years ago

    Hi Anonymous 

     

    Please share a sample of your data in a format that can be copied (paste it into the post from excel, not a screen shot) and include samples from each table involved.

     

v-diye-msft's avatar
v-diye-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous 

 

let me know if you'd like to get below result:

Add the measure: 

Measure = CALCULATE(DISTINCTCOUNT('Table'[date]),FILTER('Table',[Open]="TRUE"))