Forum Discussion

vaalyushin's avatar
vaalyushin
Icon for Helper I rankHelper I
4 years ago
Solved

percentage changes by group

Hi! I have simple dataset with date, group,number of request. I want calculate percentage changes count of requests by group (with slicer by date, month,year). I create this measures

 

Previous count requests = CALCULATE(COUNTX('Dataset','Dataset'[Number request]), PREVIOUSDAY('Calendar'[Date]))

Measure = 
var _current = COUNT('dataset'[number of request])
var _result = divide(_current - [Previous count requests],[Previous count requests],"")
return _result

 

 but it's work only for month without group

  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi vaalyushin ,

     

    Please check the PBIX file.

    If I have misunderstood your requirements, please give an example of the calculation process and post the expected output.

     

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly -- How to provide sample data

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    vaalyushin , Try a measure like

    calculate([Previous count requests], filter(allselected(Table), Table[Group] = max(Table[Group])))

     

    If this does not help
    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.