Forum Discussion

akfir's avatar
akfir
Helper V
4 years ago
Solved

bar chart calculation

Hi dear helpers, i have this kind of data table and i wish to build the correct measures/calculations in order to show this kind of bar chart (attached below). i actually need to calculate how many...
DAX
Table
  • Arul's avatar
    Arul
    4 years ago

    akfir ,

    first you need to create month name column in your table like below using below code

    Month = FORMAT('Messages Delivered'[Date],"MMM-YY")

    then create a measure using below logic then use it in your visual you will get your desired result,

    Count of meassage = 
CALCULATE(COUNT('Messages Delivered'[Customer ID]),'Messages Delivered'[Delivered?]="TRUE")

    Thanks,

    Arul

     

     

Arul's avatar
Arul
Super User
4 years ago

akfir ,

first you need to create month name column in your table like below using below code

Month = FORMAT('Messages Delivered'[Date],"MMM-YY")

then create a measure using below logic then use it in your visual you will get your desired result,

Count of meassage = 
CALCULATE(COUNT('Messages Delivered'[Customer ID]),'Messages Delivered'[Delivered?]="TRUE")

Thanks,

Arul