percentage changes by group

[vaalyushin]

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

[amitchandak]

@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.

[vaalyushin]

Unfortunately your measure doesn't work, I attached dataset 

[Anonymous · Accepted solution]

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