Forum Discussion

VGuichard's avatar
VGuichard
Frequent Visitor
4 years ago

Summarize without rows in fact table

Hello,   I'm working with data from a ticketing tool. For each location, I have a some tickets and for each ticket, a number of service unavailabity.   For each location, I need to calculate the ...
Need Help
VGuichard's avatar
VGuichard
Frequent Visitor
4 years ago

Thank you Amitchandak, but I don't understand what you want to calculate.

 

My query work for the month with data in fact table (I upddated the query with good name 🙂 😞 

 

RateOfAvailability% =
            AVERAGEX(
                          SUMMARIZE(Fact_ServiceRequest
                         ,Dim_ServiceTicket[X_NOM_COURT_ADRESSE]        --Location
                         ,Dim_Date[MoisAnnéeInt]
                        ,"RateOfAvailability%",IF(countrows(Fact_ServiceRequest)=0
                             ,1
                             ,DIVIDE(MAX(D_Date[NbDaysByMonth])*24-SUM(Fact_ServiceRequest[Nb_Of_Hours_Unavailable]),MAX(D_Date[NbDaysByMonth])*24)
                          )
           ,[RateOfUnavailability%]
           )
 
The question is how to date the month without Ticket (100 % of avaibility by defaut)
 
Thanks
  • v-janeyg-msft's avatar
    v-janeyg-msft
    Community Support
    4 years ago

    Hi, VGuichard 

     

    I didn't understand your question, do you want to show 100% in the bar chart? And is the value in the card visual correct? What's the difference between your current result and your desired result?

     

    Janey